SQL Server Interview Questions
Questions Answers Views Company eMail

How many nested transaction can possible in sql server?

Bank Of America,

3 6914

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

1 3304

Advantages and disadvantages of stored procedures.

HCL,

2 5450




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,

1019

What is the difference between online clustering and Offline clustering?

IBM,

1175

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

IBM,

3 5823

What is the diffrence between update_one and auto_fix?

IBM,

3 6710

what are the advanced features in sql 2008?

Wipro,

2 3822




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 5315

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 8078

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

1 1961

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 2643

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 3518

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 4120

What is @@Identity in sql?

Cap Gemini,

1 4073


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669


what is the sql equivaent of the dataset relation object ?

792


what exactly sql injuction.how to overcome.....

1262


what is difference between view and Dip.

1137


which backup strategy you are following at ur company

938






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

734


What is the difference between NOROW and LOCKROW?

1203


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

768


how can u get last observation in an unknown dataset ?

1083


what are the critical issues you have resloved in your company

770


How to restore performance issues and how to check?

798


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

4581


What is Lock table in SQL?

199


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

889


Why we need to use secondry database file? though, we can do same work using primary database file also.

4137