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
- 8693 Views
- I also Faced
- E-Mail Answers
Answer Posted / manub22
1.There cannot be more than 1 Primary Keys for a given table?
2.Difference between Cluster Index and non-Clustered Index, check this link: http://sqlwithmanoj.com/2011/03/02/clustered-vs-nonclustered-indexes-and-data-sorting/
3.Yes, we use query like this "Select * from Table1, Table2;". This will give a Cross Join (or cartesian-product) results from both the tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you force a query to use a specific index?
Why is sql server log file full?
what is a check constraint?
Explain following error properties?
How ssrs maintain security?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How do I find sql server instance name?
What is Lock table in SQL?
What is the difference between deallocate cursor and close cursor?
How do I partition a table in sql server?
Find nth lowest salary or get nth lowest salary?
How can you start sql server in different modes?
What are the advantages of sql azure?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
