sql-server Archives - Page 33 of 39

SQL-Server: The backup set holds a backup of a database other than the existing

I am trying to restore a SQL Server backup file for my database, but it is throwing an error as follow: The backup ...

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

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

Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?

I know I’ve done this before years ago, but I can’t remember the syntax, and I can’t find it anywhere due to pulling ...

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

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

What is the difference between Integrated Security = True and Integrated Security = SSPI?

I have two apps that use Integrated Security. One assigns Integrated Security = true in the connection string, and the other sets Integrated ...

April 30, 2022
0 Comments

SQL Server: Database stuck in “Restoring” state

I backed up a database: BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then tried to restore it: RESTORE ...

April 29, 2022
0 Comments

How to select all records from one table that do not exist in another table?

table1 (id, name) table2 (id, name) Query: SELECT name FROM table2 -- that are not in table1 already 15 s 15 SELECT t1.name ...

April 29, 2022
0 Comments

How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

I didn’t see any similar questions asked on this topic, and I had to research this for something I’m working on right now. ...

April 29, 2022
0 Comments