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
- 9241 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
What is usually the first word in a sql query?
What is difference between stored procedure and user defined function?
What is difference in performance between insert top (n) into table and using top with insert?
What is sparse columns of sql server 2008?
What are joins in sql and what are the different types of joins?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is the difference between rank and dense_rank?
How to make a column nullable?
Write a sql query to display the current date?
What is cached report?
what stored procedure would you use to view lock information? : Sql server administration
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What are click through reports?
How to list all triggers in the database with sys.triggers in ms sql server?
What do you mean by authentication modes in sql server?
