Is there any difference between primary key and unique with the not null conditi

Is there any difference between primary key and unique with the not null condition?

Question Posted / amit pant

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

More SQL Server Interview Questions

Does a sql server 2005 select statement require a from?

Call by value and call by reference in procedure and function, with NOCOPY.

What is the purpose of self join?

What command do we use to rename a db, a table and a column?

What is create statement?

Describe in brief authentication modes in sql server.

What is the difference between primary key and unique constraints?

what are candidate key, alternate key and composite key? : Sql server database administration

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

Can we insert data into view sql server?

How to truncate a table first before running a package?

What is the default value of an integer data type in sql server 2005?

For more SQL Server Interview Questions Click Here