Answer Posted / vinoth
Yes,Its Possible.Eg( Select Eid,Did,Ename from Employee)
.Create table with primary key column(Eid).This time
Primary key column ACT As a CLUSTERDE INDEX for Default.
Suppose User directly create Did COLUMN with CLUSTEREDINDEX
at this time Primary key column act as a NONCLUSTEREDINDEX.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How does a profiler work?
How to execute the cursor queries with "open" statements?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
what is difference between NULL and ISNULL in SQL Server 2008?
How to return the second 5 rows in ms sql server?
What is the federation in sql azure?
How to connect ms access to sql servers through odbc?
How many columns can we include on clustered index ?
What are system databases into sql server (2005/2008) : sql server database administration
How to integrate the ssrs reports in application?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Do you know what is difference between stored procedure and user defined function?
What is inner join in sql server joins?
