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 9023

How are SQL Server databases physically stored under Windows 2000?

1 4337

internal language used in sql server 2000?

2 4570

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

1 4864

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

1 4664

Which virtual table does a trigger use?

3 8861

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 6423

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 21666

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 7934

what is difference between having and where clause ?

3 5839

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

4 9483

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

10 18362

Un-Answered Questions { SQL Server }

What is the current limitation of the size of SQL Azure DB?

129

How do I find query history in sql server?

991

How to convert a numeric expression from one data type to another?

1100

What is default constraint in ms sql server?

1106

Does group by or order by come first?

1005

How do I completely remove sql server instance?

1155

what is raid? : Sql server database administration

1088

Can multiple columns be used in sql group by clause in ms sql server?

1119

How many types of the database links?

1120

Why SQL Agent is used?

1204

What happens when converting big values to numeric data types?

1229

Why it is recommended to avoid referencing a floating point column in the where clause?

1018

Define cursor locking

1061

Explain different types of collation sensitivity?

1037

What is BLOCK statements in SQL?

1312

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