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?

Infosys,

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?

TCS,

8 18204

How do you measure the performance of a stored procedure?

Infosys,

3 12784

Questions regarding Raiseerror?

1 5112

Questions on identity?

Infosys,

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 ?

930


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

1042


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

2947


application server is slow what may be the problem

1152


how can u get last observation in an unknown dataset ?

1244






What is RMS migrations?

1035


Comment,Datatypes are unlimited

989


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

4823


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

467


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., }

1113


what is difference between view and Dip.

1273


what are the Prerequisites for Replication?

8749


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

937


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

963


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

894