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
- 7729 Views
- I also Faced
- E-Mail Answers
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
How to update values in a table with update statements in ms sql server?
How can I change procedure name in sql server?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is enhanced database mirroring in sql server 2008?
What is a domain constraint give an example?
Difference between Inner vs outer joins?
What happens when unicode strings concatenate with non-unicode strings?
What is buffer cash and log cache in sql server?
What is the main purpose of having conversation group?
What is the default port for SQL Server over a firewall?
How do you delete duplicate records in sql server?
Detail about query optimizer?
Data table as parameter in sql server?
Explain how dts is used to extract, transform and consolidate data?
Mention the uses of stored procedures.
