Recent questions tagged SQL

0 votes

2.0k views

1 answer

sql server - SQL: programmatically copy stored procedures from one db to another

I'm looking for a way to copy stored procedures from one sql database to another on the same instance. It needs to be automatic, preferably through code ... : Using mixture of sql 2005 and 2008 versions. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sql server - Finding all Children in a Hierarchy SQL

I have a Database Hierarchy that sits somewhat like this LHID | location | parent ------------------------------ 1 | Trim | NULL ... m having trouble grasping the exact necessary syntax for it. Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

sql server - How to remove spacing between bars in column chart SSRS 2012

How can I remove spacing between bars in SSRS 2012 report. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sql server - how to write a t-sql master procedure to catch sub procedures raised error

I am new to T-SQL programming. I need to write a main procedures with 5 different sub procedures in it. How could i structure the program so that ... provide me with pseudo code if you can. Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.7k views

1 answer

sql server - SQL: Select maximum value for each unique key?

Sorry, I'm not sure how to phrase that and I'm really not very good with SQL. The db engine i SQL Server Compact. I currently have this ... queries were looking rather expensive. Thanks for all the help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

sql - Using :var with "IN" operator in WHERE clause

I'm usually working with MySQL or SQL Server and I've experienced quite a problem in Oracle SQL Developer. I have query like this (making it simple ... enter variables. Colleagues are not SQL friendly. ;) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

sql server - "Incorrect syntax" using a table-valued function in SELECT clause of T-SQL query

I have the following table-valued function for splitting strings. This works fine, was cribbed from elsewhere on the web, and I would have thought isn't the ... error, and how can I achieve what I want? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.7k views

1 answer

sql server - SSPI Connection in .Net 2.0 Web Service

I'm trying to test a .Net 2.0 Web Service I created in C#. One of our servers is on windows 2000 and can currently only support .Net 2. ... currently connect to MSSQL 2005 via classic ASP and ColdFusion. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

sql - How do I merge two tables with different column number while removing duplicates?

I have two tables in Access database. Table1 has more columns than Table2. I would like to merge those tables into one while removing duplicates. I ... above query to accomplish that? Thanks in advance. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

sql server - Aggregate strings in Azure SQL Data Warehouse

Is there a way to aggregate strings in Azure SQL Data Warehouse similar to the string_agg function in SQL Server? I have records with strings that I ... -us/sql/t-sql/functions/string-agg-transact-sql See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sql - How do I loop through a PHP array containing data returned from MySQL?

Ok I have a table with a few fields. One of the fields is username. There are many times where the username is the same, for example: username: bob ... of more than one field working for the life of me. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

sql - Natural sort supporting big numbers

I have some data like this: id | templateName ----+-------------- 10 | a 61 | a 63 | a 4 | a 6 | a 7 | a 34 | ... do that? Reference: Humanized or natural number sorting of mixed word-and-number strings See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sql - CallableStatement + registerOutParameter + multiple row result

I've got a SQL statement of the form: BEGIN UPDATE tab SET stuff WHERE stuff RETURNING intA, intB, stringC INTO ?,?,? I've registered the appropriate ... resultSet's that I need to loop over? Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.7k views

1 answer

sql - c# execute SqlCommand with Parameters in "using" code block

I am attempting to execute an SQL Command through a 'using' code block, but can't seem to get it to work with Parameters. I get the error: 'Parameters does ... ex) { //(snip) Log Exceptions } } return dt; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

sql - How to force evaluation of subquery before joining / pushing down to foreign server

Suppose I want to query a big table with a few WHERE filters. I am using Postgres 11 and a foreign table; foreign data wrapper (FDW) is clickhouse_fdw ... -calculated and sent as part of a remote filter? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sql server - How to use CTE to map parent-child relationship?

Say I have a table of items representing a tree-like structured data, and I would like to continuously tracing upward until I get to the top node, marked by ... Unfunny', 5 UNION SELECT 7, 'Dane Cook', 6 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sql server 2005 - The quest for 0x0B

I get this error when reading some data from an SQL column then converting it to XML: "System.InvalidOperationException: There is an error in XML document ( ... , char, char+% combinations, just in case) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

3.2k views

1 answer

sql - Postgresql group month wise with missing values

first an example of my table: id_object;time;value;status 1;2014-05-22 09:30:00;1234;1 1;2014-05-22 09:31:00;2341;2 1;2014-05-22 09:32:00;1234;1 ... 1;2014-06- ... : 0 0 0 0 2 1 0 0 0 0 0 0 Thx for help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sql - MySQL huge tables JOIN makes database collapse

Following my recent question Select information from last item and join to the total amount, I am having some memory problems while generation tables I ... long as I cannot change the tables structure? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k views

1 answer

sql - How to convert timestamp with milliseconds to date in Oracle

I have MSSTAMP as "timestamp with milliseconds" in Oracle, format: 1483228800000. How can I cast that milliseconds timestamp into a date format "YYYY-MM ... in ('FINISHED') group by FINISHED_MONTH ASC See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sql server - Select Name instead OF ID in table with ID-Ref Column SQL

Lets say we have 2 Tables: Table A Table B - A_ID - B_ID - A_Name - A_ID I need a select statement, that selects * from Table B showing ... another database with the same schema all the commands work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.9k views

1 answer

sql server 2005 - How to execute sp_send_dbmail while limiting permissions

Is there a way to provide access to users in my database to execute msdb.dbo.sp_send_dbmail without needing to add them to the MSDB database and the ... , database 'msdb', schema 'dbo'. Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.4k views

1 answer

sql server - Incorrect Syntax: Create Procedure must be the only statement in the batch

This question has been asked before but it all involved using "go" which I am not in need of here, at least I believe so. I am following this tut ... ' must be the first statement in a query batch." See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

sql - Query that returns multiple result sets

I have a query that will return an arbitrary number of result sets, all with the same columns - i.e. one for a Manager and then one each ... the query will generate an arbitrary number of result sets. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.9k views

1 answer

sql - Creating a cumulative sum column in MySQL

Sample table ID: (num is a key so there wouldn't be any duplicates) num 1 5 6 8 2 3 Desired output: (Should be sorted and have a cumulative sum column) num ... .num <= a.num group by a.num order by a.num; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.7k views

1 answer

sql server - Why is a cast from DATE to VARCHAR non-deterministic?

In trying to add a computed column to a SQL Server table, I've found that casting a column with a DATE type directly to a VARCHAR is considered non- ... EffDate as varchar(10)))) persisted; go Thanks, Ian See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.9k views

1 answer

sql server 2008 - Insert image into database

I'm trying to insert an image into the database. CREATE TABLE ImageTable ( Id int, Name varchar(50) , Photo varbinary(max) ) INSERT INTO ImageTable ( ... "C:caldophilus.jpg" does not exist. Please Help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

9.3k views

1 answer

sql - Inner Joining the same table multiple times

So I have received this error: #1066 - Not unique table/alias: 'Purchase' I am trying to do the following: SELECT Blank.BlankTypeCode ,Blank.BlankCode ,Payment. ... am unsure of how I can make this work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags