Answer Posted / kumar.t
Select Rows From SysIndexes Where Id = Object_Id
('tablename') And IndId<2
Uma Lakshman answer is wrong.
It Is Correct Answer
By
Kumar.T
Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Explain the architecture of ms sql reporting service?
What is the difference between varchar and nvarchar?
What are the different types of normalization?
What is the significance of master, tempdb and model databases?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Write an sql query to find first weekday of the month?
How can I track the changes or identify the latest insert-update-delete from a table?
What do you mean by a Composite primary key?
How to use old values to define new values in update statements in ms sql server?
What is the difference between a local and a global temporary table?
What is a view and what are its advantages?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How will you go about resolving deadlocks?
Explain few examples of stored procedure over triggers?