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;"
Answer Posted / debi
1.no we can't set more than one primary key for a table
3. yes we can write a query like select 8 from table1,table2
this is generally used in case of cartesian product
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
How many types of functions are there in sql server?
How do I perform an unattended install of sql server 2000?
Explain the architecture of ms sql reporting service?
List down some advantages of sql stored procedure?
How connect excel to sql server?
What is dirty read?
Do you know what is fill factor and pad index?
How will you find out if there are expensive SQL statements running or not?
What is sql server database?
What do you understand by mirroring?
What are parameterized reports?
How to create an index on a view?
What is the security model used in sql server 2005?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration