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 20662

How do SQL server 2000 and XML linked?

2 8513

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

7 16400

Explain what are db_options used for?

InterGraph,

1 9590

how to know description of a table in sqlserver 2000

8 11332

plz send every query in sql server2000

Infosys,

1 5859

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

3 8670

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 10366

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

13 28743

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

4 7355

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

3 8611

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 5553

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 5441

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

2 5694

Un-Answered Questions { SQL Server }

What is a group function explain with an example?

988

What is the difference between executequery () and executeupdate ()?

1039

Explain the microsoft sql server delete command? : SQL Server Architecture

1082

What is the cpu pressure?

1040

What is the difference between stored procedure and user defined functions?

1190

What is the use of stored procedure?

939

What is cte (common table expression)?

1032

What is the osql utility?

966

What is user-defined multi-statement table-valued function?

1061

Explain the working of sql privileges?

1091

How does using a separate hard drive for several database objects improves performance right away?

932

What does REVERT do in SQL Server 2005?

959

What is a primary index?

921

what is an index? : Sql server database administration

979

What is index, cluster index and nonclustered index?

995

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