Recent questions tagged Sql

0 votes

403 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

645 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

535 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

824 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

955 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

484 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

533 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

590 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

639 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

582 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

588 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

482 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

583 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

515 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

546 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

549 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

490 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

879 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

470 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

576 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

462 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

407 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

619 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

506 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

493 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

622 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

402 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

853 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