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 8788

How are SQL Server databases physically stored under Windows 2000?

1 4250

internal language used in sql server 2000?

2 4470

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

1 4791

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

1 4585

Which virtual table does a trigger use?

3 8716

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

1 4044

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 9651

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

3 5030

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

4 6234

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 21132

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 7806

what is difference between having and where clause ?

3 5714

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

4 9349

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

10 18069

Un-Answered Questions { SQL Server }

what is an extended stored procedure? : Sql server database administration

1055

What is partition in sql server?

1037

Why is sql server log file full?

1034

Explain what is sql server english query?

1051

How many database files are there in sql server 2000?what are they?

1051

Can we use custom code in ssrs?

1114

What is auditing in sql server?

927

What is RAID? What are the different types of RAID configurations?

1136

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

1038

What is the difference in accessing db between sql server vs sql azure?

174

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1039

How to return the date part only from a sql server datetime datatype?

1103

What is 1nf 2nf and 3nf?

891

What do you mean by data manipulation language?

1015

Explain a differential backup?

1007

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