SQL Server Interview Questions
Questions Answers Views Company eMail

What is a job?

3 3218

What are primary keys and foreign keys?

3 2908

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

3 7751




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

1 4587

How m-m relationships are implemented?

2 5811

How do you know which index a table is using?

4 8660

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

3 5382

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

2 6405




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

9 15649

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

Infosys,

4 7675

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

3 7423

Which virtual table does a trigger use?

TCS,

8 17527

How do you measure the performance of a stored procedure?

Infosys,

3 12531

Questions regarding Raiseerror?

1 4950

Questions on identity?

Infosys,

2 4272


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

334


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1016


If the job running very slow what is the action you do

687


how to take backup bcp out for a column in table in sql server?

820


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1543






Why do you want to join software field as you have done your BE in Electronics?

996


Comment,Datatypes are unlimited

894


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

683


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

755


How you trouble shoot when any job fails

651


What is data modeling and Reterminal integrity?

632


which backup strategy you are following at ur company

962


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4721


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

630


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1479