SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is a mutating table error and how can you get around it?

1040

Can we call stored procedure in trigger?

945

How do triggers work?

924

Can we write ddl in trigger?

912

What is dbcc updateusage?

1190

What is 1nf 2nf?

1001

When would you use a before or after trigger?

902

What are .mdf files?

931

What does set rowcount do?

898

What does dml stand for?

943

What is ddl and dml commands?

899

Can we use trigger new in before insert?

916

What is 2nf in normalization?

982

What triggers long term care?

1023

What do you mean by cardinality?

899

Un-Answered Questions { SQL Server }

How to turn on the mssql api module in php?

1067

What do you understand by coalesce in sql server?

1063

You want to implement the many-to-many relationship while designing tables. How would you do it?

994

What is default constraint in ms sql server?

1022

What are system databases into sql server (2005/2008)?

993

How can you stop stored procedures from recompiling?

893

What is partition, how will you implement it? : sql server analysis services, ssas

1041

What is the difference between delete and truncate statements?

1066

How to loop through result set objects using odbc_fetch_row()?

969

How to use transact-sql statements to access the database engine?

1054

What is the difference between rank and dense_rank?

1070

What program is used to store the data source file?

958

What is nonclustered index with included columns ?

960

What is the recursive stored procedure in sql server?

1017

What is amo? : sql server analysis services, ssas

1085

For More Un-Answered { SQL Server } Questions Click Here