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 20509

How do SQL server 2000 and XML linked?

2 8391

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 11095

plz send every query in sql server2000

Infosys,

1 5768

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

3 8506

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

2 11504

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

Infosys,

3 10175

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

13 28342

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 8491

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 5443

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 5351

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

2 5613

Un-Answered Questions { SQL Server }

How to copy data from one table to another table?

942

How to insert data with null values?

977

What is the main difference between ‘between’ and ‘in’ condition operators?

1119

What language is sql server written in?

993

Explain having clause and where clause?

998

What are the properties of the relational tables?

835

Explain primary key and foreign key constraints?

972

Why functions are used in sql server?

906

What extended events?

960

Differentiate between delete and truncate.

1007

What is deploy, process and build? : sql server analysis services, ssas

1047

what is checksum in sql server.........???

1636

What is primary key index?

926

Write a program to fetch first 10 records from a file?

973

What is field in algebra?

987

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