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 3573

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 2991

how to rest identity columns in sql server

Matrix,

3 9225




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 7737

What is normalization in Database ?

4 6680

Display a roll having miminum marks in two subjects?

Patni,

7 4754

Wht is SQL Injection Attack ?

3 4776

how to change column into row in sql

ESS,

4 11286




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

CMS, Impetus,

2 10730

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,

1315

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 1993

how many types of store procedre in sqlserver 2000?

ATI,

2 3518

what is the importence of the trigger in sqlserver2000?

ATI,

1 2670

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

8 17730

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 1212


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1000


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

757


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

1106


SQL Server Architecture ?

1190


what are the Prerequisites for Replication?

8670






hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1715


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?

846


How retrieve field names from the table in SQL through JAVA code?

760


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

891


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?

1315


How do you Implement SSIS Packages in your Project?

889


How to trouble shoot if unable to connect SQL Server

832


what is package and it uses and how can u call a package

948


Why we need to use secondry database file? though, we can do same work using primary database file also.

4338


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

933