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;"
Answer Posted / debi
1.no we can't set more than one primary key for a table
3. yes we can write a query like select 8 from table1,table2
this is generally used in case of cartesian product
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How do database indexes work?
What are the rendering extensions of ssrs?
What is the default port for SQL Server over a firewall?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How to disable triggers using "disable trigger"?
Which data type columns are the best candidates for full-text indexing?
what are the core components of SSRS?
Why does sql studio use a single registered database repository? : sql server management studio
how to take backup bcp out for a column in table in sql server?
What is 5nf in normalization form?
Write a query for primary key constraint with identity key word?
Where views are stored in sql server?
What is microsoft sql server?
How do I partition a table in sql server?
How is foreign key related to primary key?