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 49631

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

Cognizant, CTS,

15 16430

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 6770




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

2 4261

Alternative way to DetDate() function?

5 5539

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 36482

How to delete an attribute from the emp table

4 6103

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 2276




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

HCL,

948

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

Infosys, TCS,

18 37640

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 6509

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

4 4061

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

TCS, ABC,

4826

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

iGate, Logica CMG,

1 7233

write the query for taking database backup in sql

IBM, ABC, Logica CMG, MA,

10 29196


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

System variable and temporary variables

1015


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?

908


How to restore performance issues and how to check?

883


Why do you want to join software field as you have done your BE in Electronics?

1054


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?

980






how to take backup bcp out for a column in table in sql server?

886


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?

1295


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.

1677


How retrieve field names from the table in SQL through JAVA code?

741


What is data modeling and Reterminal integrity?

704


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1388


If user is owning any SQL Objects, can we drop that user

884


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

899


role of sql sever 2005 in database rather than any other database

908


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

860