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
- 8992 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
How to loop through result set objects using mssql_fetch_array()?
What are the built in functions in sql server?
How to defragment indexes with alter index ... Reorganize?
What are the 2 types of classifications of constraints in the sql server?
What is the difference between dataadapter and datareader?
what is a self join? : Sql server database administration
What are “lost updates”?
Explain how to integrate the ssrs reports in application?
Explain transaction isolation levels in sql server?
How do we synchronize On-Premise SQL server with SQL Azure?
How to find out what is the default collation in a database?
Explain the third normal form(3nf)?
Explain full-text indexing?
How to create user messages with print statements in ms sql server?
What is left outer join in sql server joins?
