Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / praveen
No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
How many types of database relationship in sql server?
Can you explain what are various ways to enhance the ssrs report?
Can we use pragma autonomous_transaction in trigger?
What is built-in function?
Can we add an identity column to decimal datatype?
How to create “dependant” parameter “make, model, year”
Which tcp/ip port does the sql server run on? How can it be changed?
What is save transaction and save point?
What are the hotfixes and patches in sql server?
What is a mutating table error and how can you get around it?
What are the new features of sql server 2012 reporting service?
what exactly sql injuction.how to overcome.....
What is the difference between a function and a stored procedure?
