sql Archives - Page 39 of 45

How to turn IDENTITY_INSERT on and off using SQL Server 2008?

Why am I getting an error doing an insert when IDENTITY_INSERT is set to OFF? How do I turn it on properly in ...

May 1, 2022
0 Comments

How to request a random row in SQL?

How can I request a random row (or as close to truly random as is possible) in pure SQL? 30 s 30 See ...

May 1, 2022
0 Comments

Best approach to remove time part of datetime in SQL Server

Which method provides the best performance when removing the time portion from a datetime field in SQL Server? a) select DATEADD(dd, DATEDIFF(dd, 0, ...

May 1, 2022
0 Comments

What is the difference between Left, Right, Outer and Inner Joins? [duplicate]

This question already has answers here: What is the difference between “INNER JOIN” and “OUTER JOIN”? (27 answers) Closed 6 months ago. I ...

April 30, 2022
0 Comments

Is there a Max function in SQL Server that takes two values like Math.Max in .NET?

I want to write a query like this: SELECT o.OrderId, MAX(o.NegotiatedPrice, o.SuggestedPrice) FROM Order o But this isn’t how the MAX function works, ...

April 30, 2022
0 Comments

NOT IN vs NOT EXISTS

Which of these queries is the faster? NOT EXISTS: SELECT ProductID, ProductName FROM Northwind..Products p WHERE NOT EXISTS ( SELECT 1 FROM Northwind.....

April 30, 2022
0 Comments

SQLite – UPSERT not INSERT or REPLACE

http://en.wikipedia.org/wiki/Upsert Insert Update stored proc on SQL Server Is there some clever way to do this in SQLite that I have not thought ...

April 30, 2022
0 Comments

OR is not supported with CASE Statement in SQL Server

The OR operator in the WHEN clause of a CASE statement is not supported. How can I do this? CASE ebv.db_no WHEN 22978 ...

April 30, 2022
0 Comments

Insert text with single quotes in PostgreSQL

I have a table test(id,name). I need to insert values like: user's log, 'my user', customer's. insert into test values (1,'user's log'); insert ...

April 30, 2022
0 Comments

Is it possible to insert multiple rows at a time in an SQLite database?

In MySQL you can insert multiple rows like this: INSERT INTO 'tablename' ('column1', 'column2') VALUES ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'); ...

April 29, 2022
0 Comments