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 20665

How do SQL server 2000 and XML linked?

2 8514

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

7 16404

Explain what are db_options used for?

InterGraph,

1 9592

how to know description of a table in sqlserver 2000

8 11337

plz send every query in sql server2000

Infosys,

1 5860

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

3 8675

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

2 11603

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

Infosys,

3 10369

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

13 28752

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

4 7360

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

3 8612

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 5555

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 5445

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

2 5696

Un-Answered Questions { SQL Server }

Show Practically Sql Server Views are updatable?

1123

What are the tool windows in sql server management studio? : sql server management studio

1076

What is the name of the Database which IBM mainframe uses?

987

What are synonyms?

960

Can I save my report as html, excel or word? : sql server management studio

955

How to use old values to define new values in update statements in ms sql server?

1268

Explain what is public role in sql server?

1135

What is query parameter in ssrs?

160

what does the automatic recovery do? : Sql server administration

1018

How you can move data or databases between servers and databases in sql server?

1050

What is subquery in sql?

1068

Explain the flow of creating a cube? : sql server analysis services, ssas

1050

What is mscorsvw.exe - process - microsoft .net framework ngen?

955

What is difference between line feed ( ) and carriage return ( )?

907

Define clusters?

1081

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