Answer Posted / navneet sharma
Primary cannot be a non clustered index because when you
are creating primary key on a column then by defualt
cluster index will created on that column.
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is cursors? And what are the different types of cursor?
What does it mean to invest in the index?
How to truncate the log in sql server 2012? : sql server database administration
What is Cross Join and in which scenario do we use Cross Join?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is replace and stuff function in sql server?
What are the advantages of passing name-value pairs as parameters?
What is filestream?
What is standby servers? Explain types of standby servers.
What is wide table?
Which is faster statement or preparedstatement?
Explain what is lock escalation and what is its purpose?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
what is checksum in sql server.........???
What is indexing in sql server with example?