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 20619

How do SQL server 2000 and XML linked?

2 8492

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

7 16377

Explain what are db_options used for?

InterGraph,

1 9578

how to know description of a table in sqlserver 2000

8 11293

plz send every query in sql server2000

Infosys,

1 5841

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

3 8636

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

2 11586

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

Infosys,

3 10329

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

13 28693

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

4 7331

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

3 8594

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 5533

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 5431

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

2 5679

Un-Answered Questions { SQL Server }

What is the impact on other user sessions when creating indexes?

918

Which is faster statement or preparedstatement?

932

How would we use distinct statement? What is its use?

1065

Define ACID properties in a Database?

1049

Explain how to send email from sql database?

1041

How you can find out if an index is useful to the optimizer?

929

What is inner join in sql server joins?

1026

What is resource db in sql server?

1011

How many types of database relationship in sql server?

1045

Write a SQL query to make a column as unique?

1028

Define indexes?

1035

How to execute a sql statement using odbc_exec()?

1128

What is the process of normalising?

991

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1084

what are the different ways to return the rowcount of a table?

989

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