Write a query for primary key constraint with identity key word?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain full-text query in sql server?

0 Answers  


What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  


What is b tree index?

0 Answers  


What is normalization 1nf 2nf 3nf?

0 Answers  


Difference between Function and Procedure-in general?

6 Answers  


here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,


How many partitions a clustered index has by default in sql server 2012?

0 Answers  


Explain filtered indexes?

0 Answers  


How to disable a login name in ms sql server?

0 Answers  


How to create nested stored procedure?

0 Answers  


write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  


Categories