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
- 9028 Views
- I also Faced
- E-Mail Answers
Answer Posted / koushik roy
1. A table can only have one primary key.
2. Answer #1 is right. To add it, primary key is clustered
index and when we index a column (non-primary key) it is
non-clustered index.
3. Yes this will act almost as OUTER join
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How many types of subqueries are there in sql server?
What do you understand by the data quality services in sql server?
How column data types are determined in a view?
what information is maintained within the msdb database? : Sql server administration
Explain Geometry datatype in sql server 2008 with example
How to create a view using data from another view?
How many categories of data types used by sql server?
Explain the concept of view and Types of views in SQL server?
How to manipulate data from one table to another table ?
How do I trace a query in sql server?
What is data set in report?
How do you manipulate data?
What is transact-sql ddl trigger?
Can you leave a union at any time?
New concepts of sql server 2005 use in your project.
