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
- 8690 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
How to concatenate two binary strings together?
How many levels of sp nesting are possible?
Do you know how to implement service broker?
What is a transact-sql statement?
Can we do dml on views?
Explain what is the main purpose of having conversation group?
How can you manage sql azure security?
What is for xml in sql server?
What is data source view or dsv? : sql server analysis services, ssas
What are the properties of the transactions?
What is bit data type?
When I run the sql server 2000 setup, it just hangs. What do I do?
How can we delete a table in sql server?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is oltp (online transaction processing)?
