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 6054

What are primary keys and foreign keys?

4 7616

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

3 11356

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

1 6366

How m-m relationships are implemented?

2 8218

How do you know which index a table is using?

4 12725

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

3 8286

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

2 8889

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

9 24026

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

Infosys,

4 11792

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

3 10101

Which virtual table does a trigger use?

TCS,

8 27112

How do you measure the performance of a stored procedure?

Infosys,

3 16067

Questions regarding Raiseerror?

1 6806

Questions on identity?

Infosys,

2 6910

Un-Answered Questions { SQL Server }

Explain few examples of RDBMS?

988

Can another user execute your local temporary stored procedures?

952

What is sql server used for?

1003

Explain the stored procedure?

1001

What is a view and what are its advantages?

1062

Do you know clustered and non-clustered index?

944

What is SubQuery in SQL Server 2008

975

What factors you will consider calculating the storage requirement for that view?

907

How do I start sql server agent automatically?

928

How to execute function in stored procedure sql server?

1073

Why use sub query in sql server and list out types of sub queries?

949

What is the difference between a check constraint and a rule?

1158

What is a covered index?

898

How can we migrate from SQL server to SQL Azure?

113

Is foreign key a primary key?

996

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