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 6486

Can we call SP inside a query?

CA, Wipro, CarrizalSoft Technologies,

5 6195

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

2 2066




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

TVS,

2 2880

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

TCS,

5 4360

why we use cursor?

TCS, Melstar, CarrizalSoft Technologies,

4 10368

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 )

iGate, CarrizalSoft Technologies,

3 9541

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..

TCS, 3i Infotech, Rolta,

17 8065




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

3 3349

Explain Trigger with an example?

2 9396

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 2282

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

HCL,

796

What is difference between Triggers and store procedure?

2 2741

How reterive duplicate value in SQL?

6 5768

What is Transaction?

2 3296


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to trouble shoot if unable to connect SQL Server

725


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

1096


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

1104


1 01 101 01010

689


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

796






how to use DTS package in 2000,2005,2008 in sql server

733


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

728


how to overcome kernel isssues

435


What is the difference between online clustering and Offline clustering?

1175


sql database suspect We have a sql database that is showing as suspect. How can we recover?

670


What is data modeling and Reterminal integrity?

618


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

972


whats new about truncate in sql server 2008?

1255


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.

1524


which backup strategy you are following at ur company

938