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 48720

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

Cognizant, CTS,

15 16045

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 6575




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

2 4147

Alternative way to DetDate() function?

5 5365

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 35740

How to delete an attribute from the emp table

4 5951

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 2179




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

HCL,

886

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

Infosys, TCS,

18 35771

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 6355

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

4 3930

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

TCS, ABC,

4721

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

iGate, Logica CMG,

1 7137

write the query for taking database backup in sql

IBM, ABC, Logica CMG, MA,

10 28917


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

928


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1271


If a stored procedure is taking a table data type, how it looks?

4587


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

1118


where the connection string store in the database

790






How much memory that we are using in Logshipping Concept?

674


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1235


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

589


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1124


You are doing log shipping due to some reasons it is failing. How you will proceed from there

792


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1472


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?

1221


Issues related in upgrading SQL Server 2000 to 2005 / 2008

740


How you trouble shoot when any job fails

651


what is isolation level at dead lock?

986