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
- 9017 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
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is a partitioned view?
What is raid? : SQL Server Architecture
What is a coalesce function?
What are a scheduled jobs?
In what version of sql server were synonyms released?
How to assign null values to variables or columns?
What is standby servers? Explain types of standby servers.
What is the purpose of sql profiler in sql server? : sql server database administration
How to get a list of columns in a view using "sys.columns" in ms sql server?
Can sql server be linked with other servers like oracle?
your distribution database is full what will u do
How many types of triggers are there?
How many columns can we include on clustered index ?
Explain about thread and memory management process of SQL?
