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 isnull() operator?

1037

What is coalesce in sql server?

1052

What is the use of set nocount on/off statement?

1097

What are the differences between stored procedure and the dynamic sql?

1093

How to delete duplicate rows in sql server?

1107

What will be the maximum number of index per table?

1005

What is the use of =,==,=== operators?

1013

How data can be copied from one table to another table?

950

How can we get count of the number of records in a table?

954

What is the purpose of floor function?

1039

What is tablesample?

1110

What are the differences between local and global temporary tables?

1082

What is the command used to recompile the stored procedure at run time?

1081

What are the methods used to protect against sql injection attack?

1068

Can sql servers linked to other servers?

1043

Un-Answered Questions { SQL Server }

How to update muliple row in single query?

1058

What are the different types of backups that exist?

1167

How to insert stored procedure result into temporary table?

1015

Why do we use trigger?

971

What is checkpoint in sql server?

1160

What is nested transaction?

1101

Explain different types of locks in sql server.

1079

optimization techinques

2676

What are the different types of indexes?

1118

How many types of triggers are there?

1064

Explain use of expression builder.

1017

Write an SQL query to obtain the 2nd highest salary.

1078

How to provide values to user defined function parameters?

1008

What is truncate table?

939

What is the sql server 2000 version number?

1080

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