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.

HCL,

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,

1069

What is the difference between online clustering and Offline clustering?

IBM,

1240

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

IBM,

3 6004

What is the diffrence between update_one and auto_fix?

IBM,

3 7004

what are the advanced features in sql 2008?

Wipro,

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

IBM, TCS,

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?

8518


how to overcome kernel isssues

480


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

846


how can u get last observation in an unknown dataset ?

1169


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

1122






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

1313


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.

793


application server is slow what may be the problem

1095


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

932


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

191


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

732


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

863


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.

1275


New concepts of sql server 2005 use in your project.

1247


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?

1275