SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

syntax for deleting the database in T SQL

5 9028

How are SQL Server databases physically stored under Windows 2000?

1 4338

internal language used in sql server 2000?

2 4573

What types of integrity are enforced by a foreign-key constraint

1 4865

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 4665

Which virtual table does a trigger use?

3 8862

Name three version of sql server 2000 and also their differences?

1 4118

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 9740

can you any body tell me which service pack is installed in the sql server?

3 5159

can you any body tell me the how to decrease the logfile

4 6424

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

HCL, IBM,

17 21677

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 7937

what is difference between having and where clause ?

3 5845

Accidentally i deleted my table. How can i get that table?

4 9485

how can i view structure of table in sql server? tell me that query.

10 18363

Un-Answered Questions { SQL Server }

How check triggers in sql server?

1057

How to override dml statements with triggers?

1284

Explain cursor as data base object?

1099

Explain about sql server login?

1140

What is inner join in sql server joins?

1107

What is provisioning, billing and metering, and connection routing concepts in the service layer?

115

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1458

Do you know what is difference between index seek vs. Index scan?

1008

What do you understand by triggers and mention the different types of it?

1002

What is join and name different type of joins?

1103

What is data compression? : sql server database administration

1019

What is the difference between for auto and for nested?

1070

What is the command used to check locks in microsoft sql server?

1106

What are the restraints imposed on the table design by a merge replication?

1095

Is the order of columns in the set clause important in ms sql server?

1020

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