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
- 8689 Views
- I also Faced
- E-Mail Answers
Answer Posted / anilreddy
1)No,but in single primary key we can select upto 16 columns
2)Clustered index can be only one,Nonclustered indexes can be 249
3)Yes,we can write cross join will be applied
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of using stored procedures in sql server?
What are number line correlation administrators will use while working with a subquery?
Is it safe to delete log files?
How do I find the query plan in sql server?
How do I start sql server 2016?
What is @@rowcount in sql?
What are the differences between char and nchar in ms sql server?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are the different types of sql server replication? : sql server replication
How to insert and update data into a table with "insert" and "update" statements?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is difference between drop truncate and delete?
What stored by the master? : sql server database administration
