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
- 8694 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya
1)No We can't have more than 1 primary key. Even if you try
to save it will pop an error message and nothing will be stored.
2)Clustered Index is attached with Unique. A table can have
1 and only 1 Clustered Index and it will be mostly created
on the Primary Key of the Table.
Non Clustered can be up to 254(not sure about the
number)created for a single table.
3)You can definitely select from 2 tables but all the
columns will be merged. Please check how you want the data
from those 2 tables
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a document index?
Sql server reporting services vs. Crystal reports.
What are constraints in microsoft sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is 'write-ahead log' in sql server 2000 ?
Comment,Datatypes are unlimited
What are the pre-defined functions in the sql server?
Differentiate between SQL and ORACLE joins and write their syntax.
What is a transact-sql statement batch in ms sql server?
What are the steps you must follow to hide sql server instances?
What is the sql server agent?
Explain the difference between function and stored procedure?
Find columns used in stored procedure?
How to use values from other tables in update statements in ms sql server?
Does partitioning improve performance sql server?
