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
- 8964 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
What are the different types of locks in the database?
What is the difference between composite index and covering index?
How to convert a unicode strings to non-unicode strings?
What is store procedure? When do you use?
What is parameterized reports in ssrs ?
Difference between uniqe index and uniqe constraint?
How you can get a list of all the table constraints in a database?
What is msdb database? : SQL Server Architecture
How to create an index on a view?
What is a data collection table?
Explain few of the new features of sql server 2008 management studio
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How to use subqueries in the from clause in ms sql server?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is tablix?
