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
- 8975 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhusudan bowenpalli
1. No.
2.when create primary key on a table clustered index
automatically created.1 clustered index is possible for a
table.
when we create a unique key on table Non clustered index
automatically created. 253 non clustered indexes are
possible for a table.
3. yes (its not recommended)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why use “pivot” in sql server?
What is triggers and its types?
What is normalization and denormalization in sql server?
How can you find out how many rows returned in a cursor?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What are translations and its use? : sql server analysis services, ssas
SQL Server Architecture ?
What stored by the msdb? : sql server database administration
what are the types of indexes? : Sql server database administration
Explain what are the events recorded in a transaction log?
can any body tell me how to know the password of current user in sql server
What is inline table-value user-defined function?
What is index fragmentation in ms sql server?
Define full outer join in sql server joins?
Comment,Datatypes are unlimited
