Recent questions tagged SQL

0 votes

2.7k 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 ... of sql 2005 and 2008 versions. See Question&Answers more detail:os...

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

0 votes

2.3k 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 ------------------- ... necessary syntax for it. Any ideas? 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 - 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

2.3k 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 ... pseudo code if you can. 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 - 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 ... expensive. Thanks for all the help. See Question&Answers more detail:os...

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

0 votes

2.5k 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 ... are not SQL friendly. ;) See Question&Answers more detail:os...

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

0 votes

2.6k 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 ... I achieve what I want? 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 - 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 ... 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

2.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 ... that? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

2.5k 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 ... functions/string-agg-transact-sql See Question&Answers more detail:os...

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

0 votes

2.3k 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 ... working for the life of me. See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

sql - Natural sort supporting big numbers

I have some data like this: id | templateName ----+-------------- 10 | a 61 | a 63 | ... 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

2.2k 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 ... need to loop over? 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 - 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 ... ) Log Exceptions } } return dt; 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 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; ... as part of a remote filter? See Question&Answers more detail:os...

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

0 votes

2.5k 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 ... 7, 'Dane Cook', 6 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 2005 - The quest for 0x0B

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

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

0 votes

3.8k 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; ... 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

2.3k 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 ... change the tables structure? See Question&Answers more detail:os...

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

0 votes

3.0k 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 ... ) group by FINISHED_MONTH ASC See Question&Answers more detail:os...

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

0 votes

2.3k 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, ... 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

2.5k 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 ... , schema 'dbo'. Thanks! See Question&Answers more detail:os...

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

0 votes

3.1k 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 ... first statement in a query batch." See Question&Answers more detail:os...

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

0 votes

2.5k 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 ... an arbitrary number of result sets. See Question&Answers more detail:os...

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

0 votes

2.6k 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 ... 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

2.5k 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 ... )))) persisted; go Thanks, Ian See Question&Answers more detail:os...

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

0 votes

2.8k 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 ... " does not exist. Please Help. See Question&Answers more detail:os...

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

0 votes

10.0k 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 ... 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