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
- 8973 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 want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is 2nf example?
What is a non equi join?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is the purpose of object explorer and its features? : sql server management studio
User wants only to display only pdf as export option in report manager. How to achieve this?
What is check constraint in sql server?
What is unique key constraint?
What do you mean by table and field in sql?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Is sql server free?
What are the rendering extensions of ssrs?
do views contain data ?
How does index makes search faster?
What happens if you are trying to access a schema not owned by you?
