SQL Server Interview Questions
Questions Answers Views Company eMail

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 10429

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 10480

Why we need to use secondry database file? though, we can do same work using primary database file also.

Microsoft,

2 5748

What is difference between process and thread? Explain lazy writer funcationality.

Microsoft,

2 7047

What is live lock and deadlock? what is Lock escalation?

Microsoft,

2 7762

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

RBS,

1 3677

What is Primary key and foreign key? Give an example

TCS,

4 8345

How to connect PK and FK?

2 5145

What is the SQL?????????????????????????????

CMS,

5 6433

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

1522

what is an sql server?

1 3490

find 2nd highest salary of person using cursor concept?

HCL,

6 9826

how to find the second salary?

HCL, Prithvi,

10 10548

How to swap the data of two columns in a table. both the columns containing varchar values.

9 14813

What are the steps need to be take improve the speed of a SQLDATA Server?

IBM,

2 4242


Un-Answered Questions { SQL Server }

Which is the main third-party tool used in sql server?

470


What is the difference between Triggers and Stored Procedure?

561


Why main is user defined function?

560


What is the difference between grant and with grant while giving permissions to the user?

504


How to get a list of columns in a view using "sys.columns" in ms sql server?

510






What is the difference between osql and query analyzer?

539


What is function of ROLLUP ?

640


What do you need to connect php to sql server?

528


What are different types of views?

545


What is replication with database mirroring? : sql server database administration

524


What is the usage of sign function?

582


Explain about Normalization?

557


How to move database physical files in ms sql server?

522


What is indexing explain it with an example?

544


How to find tables without indexes?

620