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 20785

How do SQL server 2000 and XML linked?

2 8602

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

7 16587

Explain what are db_options used for?

InterGraph,

1 9665

how to know description of a table in sqlserver 2000

8 11596

plz send every query in sql server2000

Infosys,

1 5933

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

3 8786

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

2 11692

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

Infosys,

3 10518

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

13 29073

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

4 7515

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

3 8707

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 5649

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 5526

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

2 5785

Un-Answered Questions { SQL Server }

What is a rownum?

1056

What is #table in sql server?

1092

Tell me what are the advantages of using stored procedures?

1060

what are the Prerequisites for Replication?

11434

When a primary key constraint is included in a table, what other constraints does this imply?

1017

What is the largest component inside a field?

1183

What is tablix?

169

How to generate create procedure script on an existing stored procedure?

1059

How to perform backup for certificates in sql server? : sql server security

1141

What is tcl in sql server?

1164

Do you know nested transaction?

994

What is a non-clustered index?

1040

How do you delete a trigger?

1027

What is a self join in sql server?

1187

How do you set a trace flag in sql server?

1084

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