Can primary key be null?

987

Can we take the full database backup in log shipping?

999

How to add more data to the testing table in ms sql server?

1172

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1167

Describe triggers features and limitations?

1057

What is the distinction amongst delete and truncate?

1121

Can I work with several databases simultaneously? : sql server management studio

1034

What is sub query and its properties?

1027

What do you mean by a Composite primary key?

1194

Can sql servers link to other servers?

1143

What is fill factor and pad index?

1066

How to list all user names in a database?

1099

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1051

Where can you find the error log information? : sql server database administration

1075

What stored procedure can you use to display the current processes?

951