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 / anilreddy
1)No,but in single primary key we can select upto 16 columns
2)Clustered index can be only one,Nonclustered indexes can be 249
3)Yes,we can write cross join will be applied
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
what are the critical issues you have resloved in your company
Explain concepts of analysis services?
If user is owning any SQL Objects, can we drop that user
how many triggers you can have on a table? : Sql server database administration
How do I port a number to sql server?
How column data types are determined in a view?
How and why use sql server?
What do you understand by the data quality services in sql server?
Tell me extended events in sql server 2008?
What are the key configuration files for sql server reporting services ?
List some case manipulation functions in sql?
What is the recovery model?
what's sql server? : Sql server database administration
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration