What are different types of constraints?
What is the default Port No on which SQL Server listens?
What is named query? : sql server analysis services, ssas
How to get number of days in a given year?
What is merge join?
What is index, cluster index and nonclustered index?
Explain user defined functions?
What is a Lock and let me know Different types of locks?
What is cdc in sql server?
How to convert numeric expression data types using the cast() function?
What is a collation in ms sql server?
what is the use of database index(apart from the last searching of records) and what is the use of composite key?
what is cursor?why we will go to cursor?advantages &disadvantages of cursors?