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?

L&T,

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

1036


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

926


What is the difference between NOROW and LOCKROW?

1367


New concepts of sql server 2005 use in your project.

1289


where the connection string store in the database

884






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

862


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

885


plss anybody specify tha constrian management system in dbms

872


your distribution database is full what will u do

1014


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

433


optimization techinques

1423


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

451


Delete duplicate rows without using rowid.

248


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

760


tell me the disaster recovery plan

1349