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
- 8696 Views
- I also Faced
- E-Mail Answers
Answer Posted / koushik roy
1. A table can only have one primary key.
2. Answer #1 is right. To add it, primary key is clustered
index and when we index a column (non-primary key) it is
non-clustered index.
3. Yes this will act almost as OUTER join
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is the default schema of your login session in ms sql server?
What is order of B+tree?
What is a view and what are its advantages?
What is onf in normalization form?
Can you use order by when defining a view?
How to select some specific rows from a table in ms sql server?
What is sql view?
Explain the microsoft sql server delete command?
Explain what is raid and what are different types of raid levels?
What is collation?
Can we use max in where clause?
How to deploy the Report?
Difference between LEN() and DATALENGTH() in sql server ?
Explain the ways to controlling cursor behavior?
