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

How to update existing rows in a table?

1 1633

How to perform key word search in tables?

965

How to display a past time in days, hours and minutes?

1019

How to query multiple tables jointly?

996

How to get the number of affected rows?

1008

How to insert data into an existing table?

984

How to include date and time values in sql statements?

1091

How to include text values in sql statements?

1046

How to loop through returning rows?

1039

How to drop an existing table?

1014

How to insert data with null values?

1040

How to insert multiple rows with a subquery?

1140

How to delete existing rows in a table?

1169

How to create an identity column?

1226

How to make a column nullable?

1125

Un-Answered Questions { SQL Server }

what are the important architecture components of SSRS?

140

Can you use order by when defining a view?

981

How you can find out if an index is useful to the optimizer?

941

What are the types of lock supported by ?

1048

Why union all is faster than union?

916

How to use the inserted and deleted pseudo tables?

967

What is the correct order of the logical query processing phases?

939

What is scrollable cursor?

1045

What is transaction server isolation?

1046

How to include text values in sql statements?

1046

What do you mean by sql server agent?

999

Explain different types of self contained sub query?

1052

How to change parameter value inside the report?

167

How many partitions a clustered index has by default in sql server 2012?

1092

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1008

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