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
- 7727 Views
- I also Faced
- E-Mail Answers
Answer Posted / manub22
1.There cannot be more than 1 Primary Keys for a given table?
2.Difference between Cluster Index and non-Clustered Index, check this link: http://sqlwithmanoj.com/2011/03/02/clustered-vs-nonclustered-indexes-and-data-sorting/
3.Yes, we use query like this "Select * from Table1, Table2;". This will give a Cross Join (or cartesian-product) results from both the tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the recovery models in sql server 2000?
How do I find query history in sql server?
Explain about service Broker functions?
Why can there be only one clustered index and not more than one?
last function used in MS Access to convert sql what function will use in sql
Do you know what guidelines should be followed to help minimize deadlocks?
Describe how to use the linked server?
Is the order of columns in the set clause important in ms sql server?
What is a synonym for manipulation?
What is a transactions?
What is the purpose of indexing?
How you trouble shoot when any job fails
What are the extra roles available in msdb? : sql server security
What are the advantages of sql stored procedure?
How do you make a trace?
