Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / samar
Primary key is also known as clusterd index which is
physical structure .And noncluster index is logical
structure .
therefore Primary key cant be a nonclustered index. and
when we are creating primary key on a table system
understands it as creation of clustered index.
this is the reason one table can have one primary key
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Where sql server user names and passwords are stored in sql server? : sql server database administration
can you implement data mining in SSRS?
What are the five characteristics of good data?
How to create a user name in a database?
What is data source object?
How to check status of stored procedure in sql server?
What program is used to store the data source file?
Define the one-to-one relationship while designing tables.
How can we rewrite sub-queries into simple select statements or with joins?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the restrictions while creating batches in sql server?
Explain about sql server login?
What is a synonym for manipulation?
What is cursors? And what are the different types of cursor?
What are the differences between having and where clause.
