1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category
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

For More Un-Answered { SQL Server } Questions Click Here