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 job?

3 6319

What are primary keys and foreign keys?

4 8609

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 11637

If a stored procedure is taking a table data type, how it looks?

1 6526

How m-m relationships are implemented?

2 8415

How do you know which index a table is using?

4 13095

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 8546

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 9081

How can you get @@error and @@rowcount at the same time?

9 24528

What are sub-queries? Give example? In which case sub-queries are not feasible?

Infosys,

4 12154

What are the type of joins? When do we use Outer and Self joins?

3 10366

Which virtual table does a trigger use?

TCS,

8 27697

How do you measure the performance of a stored procedure?

Infosys,

3 16334

Questions regarding Raiseerror?

1 6968

Questions on identity?

Infosys,

2 7128

Un-Answered Questions { SQL Server }

What is difference between order by and group by?

1058

What are date and time data types in ms sql server?

1166

What are the types of database schema? : sql server analysis services, ssas

1193

What are the advantages of paper records?

1017

What are the source of constraints?

985

How to recreate an existing index in ms sql server?

1119

What is spid in sql server profiler?

1172

What is the contrast between sql and pl/sql?

1202

between cast and convert which function would you prefer and why?

1023

What is the difference between system objects and user objects?

1220

Is BCNF better than 2NF & 3NF? Why?

1106

What is trace flag in sql server?

1085

Difference between uniqe index and uniqe constraint?

1049

Give me a SQL Query to find out the second largest company?

1232

Do you know what are the restrictions that views have to follow?

1132

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