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 are the basic features of a trigger in ms sql server?
How to get nth highest salary from employee table.
What are the different index configurations a table can have?
If a stored procedure is taking a table data type, how it looks?
Do you know what are pages and extents? : SQL Server Architecture
What is difference between inner join and full join?
What are the benefits of filtered indexes?
How many database files are there in sql server 2000?what are they?
Is sql server is free?
Can a trigger be created on a view?
What do you understand by a view? What does the with check option clause for a view do?
How to send a ssrs report from ssis?
Why truncate is ddl command?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How to create an index on an existing table in ms sql server?