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
- 9227 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhusudan bowenpalli
1. No.
2.when create primary key on a table clustered index
automatically created.1 clustered index is possible for a
table.
when we create a unique key on table Non clustered index
automatically created. 253 non clustered indexes are
possible for a table.
3. yes (its not recommended)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of using stored procedures in sql server?
How to assign null values to variables or columns?
What do you do in data exploration
How do I run sql server 2014?
What are different types of collation sensitivity?
What is triggers and stored procedures?
what is the difference between count(*) and count(1) ?
What are the different types of triggers in SQL SERVER?
Difference between drill down and drill through report.
According to you what goes into making the best database administrator? : sql server database administration
How to recover from sql injection? : sql server security
What is the parse query button used for?
Can a table have 2 primary keys?
What do you understand by coalesce in sql server?
Name some of the open source software that you can use in alternative to SSR?
