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 20508

How do SQL server 2000 and XML linked?

2 8386

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

7 16170

Explain what are db_options used for?

InterGraph,

1 9494

how to know description of a table in sqlserver 2000

8 11094

plz send every query in sql server2000

Infosys,

1 5766

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

3 8500

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

2 11502

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

Infosys,

3 10170

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

13 28339

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

4 7176

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

3 8490

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 5439

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 5349

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

2 5611

Un-Answered Questions { SQL Server }

What is the cartesian product of the table?

913

How to rename databases in ms sql server?

1133

How can sql server instances be hidden? : sql server security

1066

What are the export options of ssrs?

167

Explain stored procedure?

997

What is a domain constraint give an example?

1009

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

937

What are different type of Collation Sensitivity?

953

What are the database objects? : SQL Server Architecture

994

How to delete a database in ms sql server?

1137

Explain primary key in sql server?

978

What is enhanced database mirroring in sql server 2008?

921

Are semicolons required at the end of sql statements in sql server 2005?

939

What is the difference between stored procedure and functions?

1069

What are different types of raid configurations? : SQL Server Architecture

1016

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