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 3263

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 2819

how to rest identity columns in sql server

Matrix,

3 9008




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 7351

What is normalization in Database ?

4 6178

Display a roll having miminum marks in two subjects?

Patni,

7 4508

Wht is SQL Injection Attack ?

3 4598

how to change column into row in sql

ESS,

4 11077




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

Impetus, CMS,

2 10478

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,

1195

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 1808

how many types of store procedre in sqlserver 2000?

ATI,

2 3357

what is the importence of the trigger in sqlserver2000?

ATI,

1 2525

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

8 17297

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 1069


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

4792


Scalability, Availability, Integration with internet, etc.)?

1590


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1007


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1218


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

812






last function used in MS Access to convert sql what function will use in sql

809


Does any body please help me what question's have asked for SSRS in the interview?

795


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.

729


application server is slow what may be the problem

1049


SQL Server Architecture ?

1082


how to overcome kernel isssues

436


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

574


plss anybody specify tha constrian management system in dbms

772


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

998


1 01 101 01010

689