SQL Server Interview Questions
Questions Answers Views Company eMail

How many nested transaction can possible in sql server?

Bank Of America,

3 7097

hi,i want t0 knom d syntax for a super key with an example

1 3404

Advantages and disadvantages of stored procedures.


2 5609

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

HCL, Wipro,


What is the difference between online clustering and Offline clustering?



When do u use clustered index and non-clustered index?


3 6004

What is the diffrence between update_one and auto_fix?


3 7004

what are the advanced features in sql 2008?


2 3936

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 5503

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 8465

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 2061

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 2765

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 3679

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d


7 4286

What is @@Identity in sql?

Cap Gemini,

1 4185

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?


how to overcome kernel isssues


how can you attach more than 20 ldf files in sql server


how can u get last observation in an unknown dataset ?


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.


application server is slow what may be the problem


can any body tell me how to know the password of current user in sql server


If we delete pack Spec what will be the status of pack Body ?


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


If user is owning any SQL Objects, can we drop that user


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.


New concepts of sql server 2005 use in your project.


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?