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 the exact numeric data type in sql?

998

Which table keeps the locking information?

916

How many types of cursor type are there?

1083

How can you list all the columns in a database?

924

What is the difference between deallocate cursor and close cursor?

1251

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

977

Using the customer, and order table in northwind database, please write a query to produce xml?

1067

What is mapping schema?

1020

What is the downside of using udf?

1104

Your table has a large character field there are queries that use this field in their search clause what should you do?

879

Where can you add custom error messages to sql server?

1119

What is the primary use of the model database?

1081

what is the difference between openrowset and openquery?

1078

Why and when do stored procedure recompile?

975

How can you append an identity column to a temporary table?

944

Un-Answered Questions { SQL Server }

How to create nested stored procedure?

1013

How to compare the top two records using sql?

1339

What do you understand by replication in sql server?

1057

Explain transaction server auto commit?

1034

What are the general features of sql server management studio? : sql server management studio

1074

How to list all columns in a table using odbc_columns()?

972

what stored procedure can you use to display the current processes? : Sql server administration

1008

What is the difference between a clustered index and a non-clustered index?

986

How many types of schemas are there?

1038

Explain about temporary stored procedure?

1011

Define self join in sql server joins?

947

Can we use where clause in union?

1062

Where is my database stored on the hard disk in ms sql server?

1057

Describe triggers features and limitations?

987

Explain “not null constraint” in sql server?

1025

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