Interested to Buy Any Domain ? << Click Here >> for more details...
1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;"
- 8 Answers
- 9218 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
1.We cant see more than one primary key for the table,
however we could create composite index using clustered
index in a table.
2.Clustered index - Order the data in the physical order.
Non clustered index does not order the data
3.We can select both the table using that script which u
mentioned.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is meant by indexing files?
What is purpose of normalization?
What are the pre-defined functions in the sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
Define primary key?
Which are the third-party tools used in sql server and why would you use them?
what are the critical issues you have resloved in your company
How you can minimize the deadlock situation?
Explain what are the restrictions while creating batches in sql server?
How do I find the size of a sql server database?
How do you trace the traffic hitting a sql server?
How to delete an existing database user?
What samples and sample databases are provided by microsoft?
How to disable a login name in ms sql server?
Do you know what are the properties of the relational tables?
