Answer Posted / suresh kaudi
Primary key : Not Accept null values
Unique key : Accept Onley one null value
When you Make Primary key In a table cluster index create
Automatically mean default.
Unique Key create Automatically non-cluster index
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happens if you insert a duplicate key for the primary key column in ms sql server?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Where in ms sql server is ’100’ equal to ‘0’?
What do you understand by sql server agent?
How to convert a table data in XML format in sql server?
where the connection string store in the database
How to delete exactly duplicate records from a table?
What is row-level compre?
Explain an incremental backup?
How to write an inner join with the where clause in ms sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is the difference between inner join and equi join?
What is report server project?
How do you trace the traffic hitting a sql server?
What is a collation?