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

write the query for find the top 2 highest salary in sql server

Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

36 73959

how to retrive only second row from table in sql server 2000?

Cognizant, CTS,

15 26579

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

tdfc, vsworx,

9 11973

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 6711

Alternative way to DetDate() function?

5 9790

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

Oracle, Scend, TechInfini,

35 60033

How to delete an attribute from the emp table

4 9525

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 4524

How we create SQL Server 2005 Reporting Services ? Give me Sample

HCL,

1982

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

Infosys, TCS,

18 68184

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

Idea,

1 8845

how to find out the repeated value from table using groupby function?

4 7306

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

ABC, TCS,

5916

What is mean by "fill factor" ? and what is mean by "Index "in sql?

iGate, Logica CMG,

1 9357

write the query for taking database backup in sql

ABC, IBM, Logica CMG, MA,

10 36783

Un-Answered Questions { SQL Server }

How to drop an existing user defined function in ms sql server?

1022

What area unit the various kinds of info compression introduced in sql server 2008?

1071

Is ssrs support other database except ms sql server?

139

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1036

What is store procedure? How do they work? When do you use?

936

What is scheduled job and how to create it?

981

What are the advantages of mirroring?

985

Can a table have 2 primary keys?

978

How to use clusters?

934

How to find the second highest salary of an employee?

1168

please differentiate between delete and truncate?

988

How to read data in a table with "select" statements?

961

How to how to convert numeric expression data types using the convert() function??

1044

What do mean by xml datatype?

1086

Does group by sort data?

888

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