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
- 8971 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 entities and relationships?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What are security principals used in sql server 2005?
State a few properties of relational databases?
What are the different types of normalization?
What is rolap and its advantage? : sql server analysis services, ssas
Explain system rowset functions?
What is the most common trace flags used with sql server?
Explain magic tables in sql server?
What is spid in sql server profiler?
Is the order of columns in the set clause important in ms sql server?
What is 'Join' and explain its various types.
Explain transaction server auto commit?
What is user-defined scalar function?
What are advantages of ssrs or why we should use ssrs?
