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
- 9020 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
1.We cant see more than one primary key for the table,
however we could create composite index using clustered
index in a table.
2.Clustered index - Order the data in the physical order.
Non clustered index does not order the data
3.We can select both the table using that script which u
mentioned.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How to drop an existing stored procedure in ms sql server?
What is a cube? : sql server analysis services, ssas
What is sql azure database?
What is the Main Difference between ACCESS and SQL SERVER?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
where the connection string store in the database
How to optimize stored procedure optimization?
whats the maximum size of view state??
Can we use where and having clause together?
What is store procedure? When do you use?
What are binary string data types in ms sql server?
What is normalization of database? What are its benefits?
What is blocking and how would you troubleshoot it? : sql server database administration
If any stored procedure is encrypted, then can we see its definition in activity monitor?
