What is the difference between primary key and unique constraints?


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

Post New Answer

More SQL Server Interview Questions

What is the purpose of forms?

0 Answers  


What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,


Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  


What is master database? : SQL Server Architecture

0 Answers  


What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,






one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,


Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  


What is the difference between createstatement and preparedstatement?

0 Answers  


What will be the maximum number of indexes per table?

0 Answers  


Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  


how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,


Categories