Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh kaudi
Primary Key: Not allow null values,when we make primary key
automatically create cluster index,primary key we make
other foreign key.
Unique key: allow one null value,we can't make it foreign
key to other table.here we cane make only non-cluster index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the authentication modes in sql server? How can it be changed?
What do you mean by subquery?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Why use “pivot” in sql server?
What are null values in ms sql server?
What are indexes in sql?
How can we check the sql server version?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How to send a ssrs report from ssis?
What is attribute hierarchy? : sql server analysis services, ssas
Explain what are commit and rollback in sql?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Explain about Normalization?
How is foreign key related to primary key?
what is the difference between a primary key and a unique key? : Sql server database administration
