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

What is a NOLOCK?

NA,

3 20807

How do SQL server 2000 and XML linked?

2 8622

What is the difference between HAVING clause and the WHERE clause?

7 16626

Explain what are db_options used for?

InterGraph,

1 9675

how to know description of a table in sqlserver 2000

8 11629

plz send every query in sql server2000

Infosys,

1 5954

How to Execute an Operating System Command From Within SQL Server ?

3 8809

How can I create a plain-text flat file from SQL Server as input to another application?

2 11714

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

Infosys,

3 10547

The Difference between 'Count' and 'Count(*)'

13 29138

How do I list the available tables in a database I'm querying?

4 7539

How to count the number of duplicate items in a table?

3 8717

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 5671

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

GE,

1 5541

Is it possible to create tables in stored procedures using a variable for the table name?

2 5803

Un-Answered Questions { SQL Server }

What is an inner join?

1045

What are the general features of sql server management studio? : sql server management studio

1136

Explain an incremental backup?

1055

What stored by the master? : sql server database administration

1189

How to recover from sql injection? : sql server security

1071

What do you mean by an execution plan? How would you view it?

972

How would you use user_constraints table in DB?

1066

What does top operator do?

1081

Does group by or order by come first?

1005

What are the underflow and overflow behaviors on float literals?

1171

What stored by the tempdb ? : sql server database administration

1098

Difference between report and query parameter.

1146

What is cursors?

1264

Write a query for primary key constraint with identity key word?

1084

How can you find out how many rows returned in a cursor?

1090

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