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
- 9029 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
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Why use view instead of a table?
What do you mean by data integrity?
Explain primary key, foreign key and unique key?
What is rtm version in sql server?
What are the requirements on sql server network connections?
Which sql server table is used to hold the stored procedure scripts?
what is the system function to get the current user's user id? : Sql server database administration
What is the use of keyword with encryption. Create a store procedure with encryption?
What is indexing and its types?
When columns are added to existing tables, what do they initially contain?
What are different type of Collation Sensitivity?
What happens when transaction log is full?
What are trace files?
explain different types of cursors? : Sql server database administration
