SQL Server Interview Questions
Questions Answers Views Company eMail

How many nested transaction can possible in sql server?

Bank Of America,

3 6831

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

1 3267

Advantages and disadvantages of stored procedures.


2 5379

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 5756

What is the diffrence between update_one and auto_fix?


3 6593

what are the advanced features in sql 2008?


2 3779

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 5199

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 7866

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

1 1912

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 2577

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 3420

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 4034

What is @@Identity in sql?

Cap Gemini,

1 4016

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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


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


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


How do use Having,Group by,Group function in SQL?


What is the query optimization statistics?


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


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


last function used in MS Access to convert sql what function will use in sql


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.


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.


what is the sql equivaent of the dataset relation object ?


ow to bring suspect mode datbase online from scratch


what is difference between view and Dip.


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


whats the maximum size of view state??