sql-server Archives - Page 14 of 16

What is the significance of 1/1/1753 in SQL Server?

Why 1753? What do they have against 1752? My great great great great great great great grandfather would be very offended. 6 s ...

May 2, 2022
0 Comments

Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table? I’ve had a look through the forum but can’t ...

May 2, 2022
0 Comments

Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?

Using MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the table with the ...

May 2, 2022
0 Comments

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

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

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 do you clear the SQL Server transaction log?

I’m not a SQL expert, and I’m reminded of the fact every time I need to do something beyond the basics. I have ...

April 29, 2022
0 Comments

What is “with (nolock)” in SQL Server?

Can someone explain the implications of using with (nolock) on queries, when you should/shouldn’t use it? For example, if you have a banking ...

April 28, 2022
0 Comments

What is the difference between char, nchar, varchar, and nvarchar in SQL Server?

What is meant by nvarchar? What is the difference between char, nchar, varchar, and nvarchar in SQL Server? 12 s 12 Just to ...

April 28, 2022
0 Comments