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
- 7730 Views
- I also Faced
- E-Mail Answers
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 return the second 5 rows in ms sql server?
How to convert numeric expression data types using the cast() function?
what is a self join? Explain it with an example? : Sql server database administration
What are the steps to follow to configure SQL*Net?
where can you add custom error messages to sql server? : Sql server administration
How to create a view on an existing table in ms sql server?
How to add an address record into adventureworkslt?
What are four major operators that can be used to combine conditions on a where clause?
how many triggers you can have on a table? : Sql server database administration
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
Name few endpoints exposed by ssrs 2012?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How to delete duplicate rows from table except one?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What are the different types of triggers in SQL SERVER?
