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
- 9014 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
1.No.In a table only one primary key.we have to use the
behavior of primary key i.e in a colon to set unique key and
not null.
2.Cluster index is the leaf node directly consist a values.
and non cluster index is the leaf node consists address of
value at same task or heap.
3.No
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is the recovery model? List the types of recovery model available in sql server?
How to add the custom code in Report?
Why and when do stored procedure recompile?
What is TDS(Tabular Data Stream) Gateway?
What is mean by dml?
what is the system function to get current user's user id? : Sql server database administration
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are acid properties of transaction?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Can I use sql azure as a backup with log shipping or database mirroring?
How to create a stored procedure with a statement block in ms sql server?
Mention the different types of replication in sql server.
List the different index configurations possible for a table?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is the stuff and how does it differ from the replace function?
