SQL Server Interview Questions
Questions Answers Views Company eMail

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 3418

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 2899

how to rest identity columns in sql server

Matrix,

3 9113




i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

IBM,

9 7532

What is normalization in Database ?

4 6486

Display a roll having miminum marks in two subjects?

Patni,

7 4641

Wht is SQL Injection Attack ?

3 4691

how to change column into row in sql

ESS,

4 11190




What are the advantages of using sql server over ms access or why should one use sql instead of ms access

Impetus, CMS,

2 10613

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

ABC,

1256

How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

INDUS,

1 1890

how many types of store procedre in sqlserver 2000?

ATI,

2 3434

what is the importence of the trigger in sqlserver2000?

ATI,

1 2581

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 17483

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

Fidelity,

1 1127


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to restore performance issues and how to check?

844


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

863


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1102


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1252


What is data modeling and Reterminal integrity?

668






If user is owning any SQL Objects, can we drop that user

852


If the job running very slow what is the action you do

713


wat wil hapn if we give the both read and deny read permission to user?

931


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

847


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


which backup strategy you are following at ur company

992


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.

771


what is difference between view and Dip.

1206


how to use DTS package in 2000,2005,2008 in sql server

779


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1256