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
- 8900 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
How to execute the cursor queries with "open" statements?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
Explain about system database?
How does index makes search faster?
Call by value and call by reference in procedure and function, with NOCOPY.
what is a mixed extent? : Sql server administration
What are the different Topologies in which Replication can be configured?
role of sql sever 2005 in database rather than any other database
What happens if you are trying to access a schema not owned by you?
How to populate a table in sql server?
Can we perform backup restore operation on tempdb? : sql server database administration
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What do you understand by the analysis services in sql server?
Do you know what is lock escalation?
How many levels of sp nesting is possible?
