Answer Posted / hari
Primary key : Doen't allow null values
Unique key : allow one null value
Primary key create cluster index
Unique Key create non-cluster index
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How you can find out if an index is useful to the optimizer?
Do you know the policy based administration feature of sql server 2008?
Which is the main third-party tool used in sql server?
Explain transaction server consistency?
Can a rule be bound to any column of any data type?
What is field in algebra?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How can you insert values in multiple rows using one Insert statement?
What are the types of user defined functions in sql server?
What are the differences between triggers and stored procedures?
How many types of stored procedures are there in sql server?
What are secondary xml indexes?
What are logical/boolean operations in ms sql server?
