SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

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 7818

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 5424

how to rest identity columns in sql server

Matrix,

3 12351

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 13722

What is normalization in Database ?

4 10787

Display a roll having miminum marks in two subjects?

Patni,

7 8895

Wht is SQL Injection Attack ?

3 7606

how to change column into row in sql

ESS,

4 15376

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

CMS, Impetus,

2 13606

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,

2581

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 4332

how many types of store procedre in sqlserver 2000?

ATI,

2 5906

what is the importence of the trigger in sqlserver2000?

ATI,

1 4367

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

8 23636

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 3023

Un-Answered Questions { SQL Server }

What is the difference between the application object and session object?

1066

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1053

Write SQL queries on Self Join and Inner Join.

1154

Explain index in sql server?

1012

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 ...

2036

Define clusters?

1075

How to write a query with a full outer join in ms sql server?

1076

How to use subqueries with the exists operators in ms sql server?

1119

How to Update from select query in sql server?

1060

What is tempdb in sql server?

972

Can sql servers linked to other servers like oracle?

953

What do you mean by stored techniques? How would we use it?

1034

How to list all field names in the result set using mssql_field_name()?

914

Explain “row_number()” in sql server with an example?

1002

What are different types of statement?

1017

For More Un-Answered { SQL Server } Questions Click Here