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
- 9220 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
1.No.In a table only one primary key.we have to use the
behavior of primary key i.e in a colon to set unique key and
not null.
2.Cluster index is the leaf node directly consist a values.
and non cluster index is the leaf node consists address of
value at same task or heap.
3.No
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is etl - extraction, transformation, and loading?
What are the key configuration files for sql server reporting services ?
Does view occupy space?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Write a SQL queries on Self Join and Inner Join.
how to use DTS package in 2000,2005,2008 in sql server
Explain differentiate between a having clause and a where clause?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Explain Reporting Life Cycle?
What are the advantages of sql stored procedure?
Why union all is faster than union?
What is bit data type? What's the information that can be stored inside a bit column?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
