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 2734

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

2 16677

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

HCL, CarrizalSoft Technologies,

10 8107




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

1 15448

What is Peer to peer Replication?

HCL, CarrizalSoft Technologies,

1 4017

what is a cursor and what is its use?

L&T,

2 5296

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

7 4608

what is trigger

NIIT, CarrizalSoft Technologies,

1 2721




what is difference between nchar and char in Sql server ?

3 5052

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

3 3528

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 2952

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

Sonata, CarrizalSoft Technologies,

7 5634

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 2193

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 2067

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

8 7518


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

OPTIMIZATION OF SP,CURSOR,TRIGGERS

1457


How you trouble shoot when any job fails

629


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

2709


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669


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

771






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

338


System variable and temporary variables

928


Which is the best place or learning center for MS SQL?????In Bangladesh?????

828


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.

728


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

908


SQL Server Architecture ?

1080


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

847


Comment,Datatypes are unlimited

871


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

131


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

4788