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 6651

Can we call SP inside a query?

CA, Wipro, CarrizalSoft Technologies,

5 6287

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

2 2129




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

TVS,

2 2935

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

TCS,

5 4456

why we use cursor?

TCS, Melstar, CarrizalSoft Technologies,

4 10483

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 9628

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 8208




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

3 3418

Explain Trigger with an example?

2 9500

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 2337

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

HCL,

830

What is difference between Triggers and store procedure?

2 2814

How reterive duplicate value in SQL?

6 5843

What is Transaction?

2 3362


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Issues related in upgrading SQL Server 2000 to 2005 / 2008

754


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1254


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

4745


Which is the best place or learning center for MS SQL?????In Bangladesh?????

864


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

697






Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

923


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

927


your distribution database is full what will u do

944


What is the difference between online clustering and Offline clustering?

1213


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

870


query processing

991


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

585


How you trouble shoot when any job fails

674


what exactly sql injuction.how to overcome.....

1301


Explain Capacity planning to create a database? and how to monitor it?

2777