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 2878

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

2 17214

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

HCL, CarrizalSoft Technologies,

10 8524

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

1 16085

What is Peer to peer Replication?

HCL, CarrizalSoft Technologies,

1 4183

what is a cursor and what is its use?


2 5627

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

7 4865

what is trigger

NIIT, CarrizalSoft Technologies,

1 2902

what is difference between nchar and char in Sql server ?

3 5273

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

3 3727

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 3221

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

Sonata, CarrizalSoft Technologies,

7 5859

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 2348

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 2244

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

8 7816

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

System variable and temporary variables


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance


What is the difference between NOROW and LOCKROW?


New concepts of sql server 2005 use in your project.


where the connection string store in the database


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram


You are doing log shipping due to some reasons it is failing. How you will proceed from there


plss anybody specify tha constrian management system in dbms


your distribution database is full what will u do


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A


optimization techinques


what is checksum in sql server.........???


Delete duplicate rows without using rowid.


How retrieve field names from the table in SQL through JAVA code?


tell me the disaster recovery plan