sql-server Archives - Page 10 of 16

How to check if a Constraint exists in Sql server?

I have this sql: ALTER TABLE dbo.ChannelPlayerSkins DROP CONSTRAINT FK_ChannelPlayerSkins_Channels but apparently, on some other databases we use, the constraint has a different ...

May 15, 2022
0 Comments

Format SQL in SQL Server Management Studio

In Visual Studio & other IDEs, you can easily auto format your code with a keyboard shortcut, through the menu, or automatically as ...

May 15, 2022
0 Comments

When should I use a table variable vs temporary table in sql server?

I’m learning more details in table variable. It says that temp tables are always on disk, and table variables are in memory, that ...

May 15, 2022
0 Comments

Login to Microsoft SQL Server Error: 18456

I am getting this error while trying to connect to the SQL Server. Microsoft SQL Server Error: 18456 Can anybody tell me what ...

May 14, 2022
0 Comments

How can I clone an SQL Server database on the same server in SQL Server 2008 Express?

I have an MS SQL Server 2008 Express system which contains a database that I would like to ‘copy and rename’ (for testing ...

May 14, 2022
0 Comments

How do you check if a certain index exists in a table?

Something like this: SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME ='FK_TreeNodesBinaryAssets_BinaryAssets' and TABLE_NAME = 'TreeNodesBinaryAssets' but for indexes. 9 Answers 9

May 14, 2022
0 Comments

Add default value of datetime field in SQL Server to a timestamp

I’ve got a table that collects forms submitted from our website, but for some reason, when they created the table, they didn’t put ...

May 13, 2022
0 Comments

How to do version control for SQL Server database?

I want to get my databases under version control. I’ll always want to have at least some data in there (as alumb mentions: ...

May 13, 2022
0 Comments

Why do table names in SQL Server start with “dbo”?

At least on my local instance, when I create tables, they are all prefixed with “dbo.”. Why is that? 6 Answers 6

May 11, 2022
0 Comments

How do I use cascade delete with SQL Server?

I have 2 tables: T1 and T2, they are existing tables with data. We have a one to many relationship between T1 and ...

May 10, 2022
0 Comments