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


SQL Server Interview Questions
Questions Answers Views Company eMail

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

TCS,

8 10442

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 8917

Can some one please help with a query which will take only max value of a column in a join.

 2 3374

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

TVS,

2 4401

which database is best to use in oracle and sql server? explain reasons?

TCS,

5 6649

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 13266

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

CarrizalSoft Technologies, iGate,

3 11605

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

3i Infotech, Rolta, TCS,

17 14375

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

 3 5152

Explain Trigger with an example?

2 11185

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

 3 4211

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

HCL,

1481

What is difference between Triggers and store procedure?

 2 4439

How reterive duplicate value in SQL?

 6 8745

What is Transaction?

 2 4862

Un-Answered Questions { SQL Server }

What is difference between global temporary tables and local temporary tables?

654

Explain the properties of sub-query in sql server?

500

what is a schema in sql server 2005? : Sql server database administration

508

Define full outer join?

514

What is the default fill factor value?

572




What is a virtual table in sql?

543

What is code near application topology?

197

How check triggers in sql server?

512

How is sql used in sql server?

493

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

545

Tell me what is fill factor?

547

What are the different editions available in sql server 2000?

582

What is save transaction and save point?

615

How to write a query with a left outer join in ms sql server?

566

What are filegroups in sql server?

572

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