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 49105

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

Cognizant, CTS,

15 16202

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 6661




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

2 4207

Alternative way to DetDate() function?

5 5429

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 36035

How to delete an attribute from the emp table

4 6017

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 2227




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

HCL,

920

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

Infosys, TCS,

18 36637

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 6408

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

4 3982

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

TCS, ABC,

4769

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

iGate, Logica CMG,

1 7179

write the query for taking database backup in sql

IBM, ABC, Logica CMG, MA,

10 29025


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Call by value and call by reference in procedure and function, with NOCOPY.

150


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.

1618


Working with TLogs

683


whats new about truncate in sql server 2008?

1310


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

904






code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1040


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

656


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

313


System variable and temporary variables

980


on line cluster can we make if yes tell me the procedure

837


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

1253


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

1152


Delete duplicate rows without using rowid.

191


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

362


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

1501