what is difference between primary key and Unique

Answer Posted / naresh

Primary key:it can not be null

Unique:it can have only one null value in a table.

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is 1nf 2nf?

545


How to create function with parameter in sql server?

557


Differentiate between a having clause and a where clause.

518


What is cte (common table expression)?

595


Will the writetext statement activate a trigger?

566






What is the purpose of the master database?

602


What is table valued function and scalar valued functions?

489


What are different types of roles provided by ssrs?

112


List the different types of joins?

566


How to execute stored procedure and set temp table in sql server?

550


can you implement data mining in SSRS?

113


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

551


You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

243


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

514


explain databases and sql server databases architecture? : Sql server database administration

519