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 6167

What are primary keys and foreign keys?

4 8135

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

3 11479

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

1 6448

How m-m relationships are implemented?

2 8308

How do you know which index a table is using?

4 12908

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

3 8431

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

2 8977

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

9 24286

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

Infosys,

4 11952

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

3 10237

Which virtual table does a trigger use?

TCS,

8 27404

How do you measure the performance of a stored procedure?

Infosys,

3 16189

Questions regarding Raiseerror?

1 6873

Questions on identity?

Infosys,

2 7019

Un-Answered Questions { SQL Server }

What’s the use of custom fields in report?

944

How to find the second highest salary of an employee?

1179

Explain about link server in sql server?

1056

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075

what are the three command line utilities and what are their primary functions?

144

Explain syntax for dropping triggers?

928

What is transaction server consistency?

1046

What does <> symbol mean?

974

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

882

What do you understand by physical_only option in dbcc checkdb?

979

How to access the deleted record of an event?

1040

What is the use of for clause?

1118

How to encrypt data between dialogs?

1107

How to test a dml trigger in ms sql server?

1042

What is data source in connection string?

907

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