Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



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 55618

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

Cognizant, CTS,

15 18605

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 7930

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

2 4777

Alternative way to DetDate() function?

5 6561

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 41173

How to delete an attribute from the emp table

4 6876

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 2703

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

HCL,

1216

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

Infosys, TCS,

18 46634

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 7049

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

4 4759

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

ABC, TCS,

5119

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

iGate, Logica CMG,

1 7666

write the query for taking database backup in sql

ABC, IBM, Logica CMG, MA,

10 30826







Un-Answered Questions { SQL Server }

What is the temp table?

159


what kind of lan types do you know? : Sql server database administration

180


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

150


How can you swap values between two rows in a table using single- SQL statement?

197


Can sub report data source be different from that of the parent report?

29






Mention the different authentication modes in sql server.

157


What is difference between order by and group by?

152


Explain the functionalities that views support?

236


What is set nocount on and what is set nocount off?

173


What is model database in sql server?

136


what are the Prerequisites for Replication?

9805


Explain logical operators in sql server?

179


What is the data type of time?

135


What are the extra roles available in msdb? : sql server security

172


When would you use a before or after trigger?

123