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
- 7719 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya
1)No We can't have more than 1 primary key. Even if you try
to save it will pop an error message and nothing will be stored.
2)Clustered Index is attached with Unique. A table can have
1 and only 1 Clustered Index and it will be mostly created
on the Primary Key of the Table.
Non Clustered can be up to 254(not sure about the
number)created for a single table.
3)You can definitely select from 2 tables but all the
columns will be merged. Please check how you want the data
from those 2 tables
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are binary string data types in ms sql server?
What is a partition function in sql server?
What are the types of database schema? : sql server analysis services, ssas
In which files does sql server actually store data?
What are the options which must be set to allow the usage of optimistic models?
What is difference between delete and truncate commands?
What is 1nf 2nf?
What is bulkcopy in sql?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Where the sql logs gets stored? : sql server database administration
What command do we use to rename a database?
Explain the different types of joins?
Determine when to use stored procedure to complete sql server tasks?
What are the differences between local and global temporary tables?
Would you store your query in a ssrs report or a database server? State the reason why?
