SQL Server Interview Questions
Questions Answers Views Company eMail

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 2696

what is the main difference between after trigger and instead trigger.

2 16374

I have to display ten columns values from diffrent ten tables. how many joins are require?

HCL, CarrizalSoft Technologies,

10 7980

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 15208

What is Peer to peer Replication?

HCL, CarrizalSoft Technologies,

1 3980

what is a cursor and what is its use?


2 5185

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 4544

what is trigger

NIIT, CarrizalSoft Technologies,

1 2684

what is difference between nchar and char in Sql server ?

3 4960

How can we write or define DDL statements in Sql server and DML statements?

3 3482

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 2882

write down the code for "how we delete a table without using of Drop command " ?

Sonata, CarrizalSoft Technologies,

7 5556

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 2138

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 2014

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 7433

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Comment,Datatypes are unlimited


ow to bring suspect mode datbase online from scratch


what is difference between view and Dip.


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.


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


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60


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


What is the difference between online clustering and Offline clustering?


whats new about truncate in sql server 2008?


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


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


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks


what is the Ticketing tool used in Wipro technologies at Bangalore...???


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


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.