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 6168

What are primary keys and foreign keys?

4 8136

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 8310

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 8978

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

9 24287

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

Infosys,

4 11953

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

3 10238

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 }

How to use union to merge outputs from two queries together in ms sql server?

1069

How does index makes search faster?

979

how to use DTS package in 2000,2005,2008 in sql server

1838

Define msdb database?

1016

What are the new scripting capabilities of ssms? : sql server management studio

1067

What is the difference between char and varchar2 datatype in sql?

1066

When we should use @@error?

965

How to create a new schema in a database?

1151

What is failover clustering overview?

1088

What is sql server agent and what are the two modes of authentication in sql server?

1056

What is difference between views and stored procedures?

989

How do you create an execution plan?

948

What are the steps you should follow to start sql server in single-user mode?

904

How to modify an existing stored procedure in ms sql server?

1079

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1027

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