1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 65869

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

Cognizant, CTS,

15 22368

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 9829

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

 2 5808

Alternative way to DetDate() function?

 5 8043

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 51266

How to delete an attribute from the emp table

 4 8110

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 3640

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

HCL,

1573

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

Infosys, TCS,

18 62351

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 7992

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

 4 5894

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

ABC, TCS,

5495

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

iGate, Logica CMG,

1 8406

write the query for taking database backup in sql

ABC, IBM, Logica CMG, MA,

10 33955

Un-Answered Questions { SQL Server }

Define outer join?

531

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1501

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

134

Define candidate key, alternate key, and composite key.

532

What is user-defined scalar function?

555




What method is used by the Command classes to execute SQL statements that return single values?

602

What is the downside of using udf?

557

Does partitioning help performance?

527

How to bind a view to the schema of the underlying tables?

587

Does group by sort data?

511

What is scrollable cursor?

543

How many levels of sp nesting is possible?

586

What is merge replication?

710

Explain triggers in sql?

552

What is a DBMS, query, SQL?

575

For More Un-Answered { SQL Server } Questions Click Here