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
- 8991 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 extended events?
What is the importance of a recovery model?
What is tcl in sql server?
What are points to remember while using the fillfactor argument?
Does server sql treat char as a variable-length or fixed-length column?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Does a server store data?
what is an extended stored procedure? : Sql server database administration
What is sql service broker?
What is model database in sql server?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What is user-defined scalar function?
Explain primary key in sql server?
Do you know the cursor optimization tips?
How to use linked server?
