Recent questions tagged SQL

0 votes

375 views

1 answer

sql server - Using temp table with exec @sql in stored procedure

I have a stored procedure and part of them as below: @DRange is a incoming varchar value declare @sql varchar(max ... did I do something wrong? See Question&Answers more detail:os...

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

0 votes

605 views

1 answer

sql - Get the number of affected rows in a MySQL update statement?

I have stored procedure in MySQL, something like the below: create procedure SP_Test (input1 varchar(20)) begin ... changed by this update? See Question&Answers more detail:os...

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

0 votes

493 views

1 answer

sql - Do I need to call rollback if I never commit?

I am connecting to a SQL Server using no autocommit. If everything is successful, I call commit. Otherwise, ... explicitly commit or rollback. See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

sql - Does SQLite support SCOPE_IDENTITY?

I'm trying to perform a simple INSERT and return the identity (auto-incrementing primary key). I've tried ... "thread-safe") alternatives? See Question&Answers more detail:os...

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

0 votes

910 views

1 answer

sql server - FreeTDS working, but ODBC cannot connect

I am trying to run connect to a MSSQL server from an Ubuntu 12.04 webserver with FreeTDS and unixODBC. Using tsql i ... too stupid to see it :D See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql server - Group by every N records in T-SQL

I have some performance test results on the database, and what I want to do is to group every 1000 records ( ... FROM dbo.Results ORDER BY id See Question&Answers more detail:os...

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

0 votes

500 views

1 answer

sql - Add a Column that Represents a Concatenation of Two Other Varchar Columns

I have an employees table and I want to add a third column valued as the concatenation of the first and last ... of the first two columns? See Question&Answers more detail:os...

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

0 votes

558 views

1 answer

sql - Conversion failed when converting from a character string to uniqueidentifier

Created a stored procedure in SQL 9 (2005) and have since upgraded to SQL 10 (2008). Since then, the ... in advance for your help. James See Question&Answers more detail:os...

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

0 votes

606 views

1 answer

sql - Implications of nvarchar (50) vs nvarchar (max)

What are the general storage and performance differences between the below two tables if their only difference is ... username nvarchar (max) See Question&Answers more detail:os...

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

0 votes

541 views

1 answer

sql - How to allow only one row for a table?

I have one table in which I would like only one entry. So if someone is trying to insert another row it shouldn ... rule for a table like this? See Question&Answers more detail:os...

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

0 votes

552 views

1 answer

sql server - Declaring variable type based on a column type

In Oracle's PL-SQL, you can declare a variable and define its type based on a table column: declare var1 ... something similar in MS SQL Server? See Question&Answers more detail:os...

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

0 votes

441 views

1 answer

sql server - What are the differences between CHECKSUM() and BINARY_CHECKSUM() and when/what are the appropriate usage scenarios?

Again MSDN does not really explain in plain English the exact difference, or the information for when to choose one ... changes, but not why. See Question&Answers more detail:os...

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

0 votes

542 views

1 answer

sql - how to group by and return sum row in Postgres

I am stuck here. I have row in Postgres like this: id amount a 5000 a 1500 a 500 b 2000 b 1000 c 4000 How ... ? id amount a 7000 b 3000 c 4000 See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

sql server - Why there is an extra "(1 row(s) affected)"

The SSMS shows an extra (1 row(s) affected) every time when I execute insert/update. For example, execute the ... extra (1 row(s) affected)? See Question&Answers more detail:os...

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

0 votes

510 views

1 answer

sql server - How can I force a subquery to perform as well as a #temp table?

I am re-iterating the question asked by Mongus Pong Why would using a temp table be faster than a nested query? ... the special hint is X... See Question&Answers more detail:os...

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

0 votes

522 views

1 answer

sql - How to programmatically create a Java ResultSet from custom data with no database

I have some existing code that accepts a java.sql.ResultSet that contains info retrieved from an Oracle database. ... find any good pointers. See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql - Postgres won't accept table alias before column name

I'm using a framework (Jodd) which is adding the table alias to the column names in a SQL Select. It looks like ... which I don't want to do. See Question&Answers more detail:os...

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

0 votes

844 views

1 answer

sql - IDENTITY_INSERT is already ON for table 'X'. Cannot perform SET operation for table 'Y'

I created a trigger that performs a check and automatically populates data into 2 tables. Only what happens the ... i end DataBase---- See Question&Answers more detail:os...

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

0 votes

433 views

1 answer

sql - Update columns with Null values

I tried updating a table as follows: update userloginstats set logouttime = sysdate where logouttime = null; It ... values. What went wrong? See Question&Answers more detail:os...

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

0 votes

535 views

1 answer

sql server - C# SQL Top as parameter

Trying to parameterize the value of TOP in my sql statement. SELECT TOP @topparam * from table1 command. ... to use stored procedures. See Question&Answers more detail:os...

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

0 votes

422 views

1 answer

sql - Grouping by a Top N in MySQL

There are a lot of SQL Top N questions on stackoverflow but I can't seem to find one that matches the situation ... UNION. Thanks for the help! See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql server - Keyword to SQL search

Use Case When a user goes to my website, they will be confronted with a search box much like SO. They ... sql query. Thoughts/suggestions/links? See Question&Answers more detail:os...

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

0 votes

566 views

1 answer

sql - Merge overlapping time intervals, how?

Anyone could help me in a query that **merge a interval of datas? ex: Common select: SELECT id, date_start, date_end ... 19:00:00 Thanks a lot! See Question&Answers more detail:os...

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

0 votes

474 views

1 answer

sql - Retrieving a row, with data from key-value pair table in MySQL

I have two tables, one called customer and one called customer_attributes. The idea is that the customer table ... 'wedding_date' and 'test' See Question&Answers more detail:os...

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

0 votes

455 views

1 answer

sql server 2008 - CTE returning error

I wrote a CTE to remove non numeric values from a data set, then get a count of numeric values within a range ... -WHERE CONVERT(INT,result) > 1 See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

sql - MAX(id) using SqlDataReader C#

How do I change this: using (SqlCommand myCommand = myConnection.CreateCommand()) { myConnection.Open(); ... an IndexOutOfRange exception. See Question&Answers more detail:os...

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

0 votes

368 views

1 answer

sql - To get column names from table having a particular value

Please tell me How to get column names where column value =123 for a particular row.Thanks in advance . See Question&Answers more detail:os...

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

0 votes

786 views

1 answer

sql - How to avoid race condition in MySQL

I've got a potential race condition in an application I'm developing, which I'd like to account for and ... the most suitable solution for me. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags