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 2796

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

2 16973

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

HCL, CarrizalSoft Technologies,

10 8294




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

1 15792

What is Peer to peer Replication?

HCL, CarrizalSoft Technologies,

1 4108

what is a cursor and what is its use?

L&T,

2 5454

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

7 4728

what is trigger

NIIT, CarrizalSoft Technologies,

1 2815




what is difference between nchar and char in Sql server ?

3 5167

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

3 3617

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 3081

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

Sonata, CarrizalSoft Technologies,

7 5739

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 2274

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 2145

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

8 7678


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

If a stored procedure is taking a table data type, how it looks?

4645


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

879


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2676


whats the maximum size of view state??

948


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

858






query processing

1000


optimization techinques

1330


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

781


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

362


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?)

712


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1040


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1151


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

676


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1510


on line cluster can we make if yes tell me the procedure

837