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 20485

How do SQL server 2000 and XML linked?

2 8360

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

7 16127

Explain what are db_options used for?

InterGraph,

1 9472

how to know description of a table in sqlserver 2000

8 11032

plz send every query in sql server2000

Infosys,

1 5750

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

3 8473

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

2 11482

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

Infosys,

3 10138

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

13 28244

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

4 7149

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

3 8466

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 5420

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 5334

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

2 5594

Un-Answered Questions { SQL Server }

Is it safe to delete log files?

867

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1853

How to write character string constants or literals in ms sql server?

958

what is package and it uses and how can u call a package

1951

Is it possible to call a stored procedure within a stored procedure?

914

Do you know what is lock escalation?

963

How to provide values to user defined function parameters?

967

Explain comment on transactions?

934

Explain collation?

1003

how many type of indexing in database?

934

What are the grouping functions?

889

Explain powershell included in sql server 2008?

998

what is a schema in sql server 2005? : Sql server database administration

956

How to create a simple user defined function in ms sql server?

969

Can you name some of the dml commands in sql?

961

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