SQL Server Interview Questions
Questions Answers Views Company eMail

What is a job?

3 3401

What are primary keys and foreign keys?

3 3066

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

3 8086

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

1 4791

How m-m relationships are implemented?

2 6005

How do you know which index a table is using?

4 8841

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

3 5533

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

2 6563

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

9 16318

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


4 7930

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

3 7566

Which virtual table does a trigger use?


8 18204

How do you measure the performance of a stored procedure?


3 12784

Questions regarding Raiseerror?

1 5112

Questions on identity?


2 4531

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?


What is best institute to Learn DotNET And SQL in chennai?


Explain Capacity planning to create a database? and how to monitor it?


application server is slow what may be the problem


how can u get last observation in an unknown dataset ?


What is RMS migrations?


Comment,Datatypes are unlimited


How can we call UDF(User Define Function) using C# code in ASP.net ?


what is checksum in sql server.........???


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }


what is difference between view and Dip.


what are the Prerequisites for Replication?


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?