SQL Server Interview Questions
Questions Answers Views Company eMail

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

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

36 48311

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

Cognizant, CTS,

15 15904

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

vsworx, tdfc,

9 6533




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

2 4106

Alternative way to DetDate() function?

5 5304

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 35529

How to delete an attribute from the emp table

4 5898

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 2148




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

HCL,

867

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

Infosys, TCS,

18 35044

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 6323

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

4 3890

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

TCS, ABC,

4686

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

iGate, Logica CMG,

1 7107

write the query for taking database backup in sql

IBM, ABC, Logica CMG, MA,

10 28817


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how to do partition in sqlserver

1264


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

794


what is checksum in sql server.........???

338


how to use DTS package in 2000,2005,2008 in sql server

733


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

889






What are the dis_advantages of stored procedures, triggers, indexes?

902


how many no of arguments can be passed in procedures and functions

3421


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.

1524


1 01 101 01010

689


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1192


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

827


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1457


How do you Implement SSIS Packages in your Project?

789


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

816


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1096