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
- 8898 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 sort query output in descending order in ms sql server?
Why use update_statistics command in sql server?
What is store procedure? How do they work?
What is a constant or literal in ms sql server?
Explain the difference between control flow and data flow?
Which tcp/ip port does sql server run on? How can it be changed?
Can we use pragma autonomous_transaction in trigger?
What will be the maximum number of indexes per table?
What do you understand by user-defined function in the sql server?
How to handle error or exception in sql?
what is raid and what are different types of raid configurations? : Sql server database administration
What is use of @@ spid in sql server?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Name the different type of indexes in sql?
