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 the exact numeric data type in sql?

1007

Which table keeps the locking information?

933

How many types of cursor type are there?

1098

How can you list all the columns in a database?

938

What is the difference between deallocate cursor and close cursor?

1269

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

986

Using the customer, and order table in northwind database, please write a query to produce xml?

1082

What is mapping schema?

1036

What is the downside of using udf?

1117

Your table has a large character field there are queries that use this field in their search clause what should you do?

887

Where can you add custom error messages to sql server?

1131

What is the primary use of the model database?

1095

what is the difference between openrowset and openquery?

1094

Why and when do stored procedure recompile?

989

How can you append an identity column to a temporary table?

963

Un-Answered Questions { SQL Server }

What does <> symbol mean?

984

How adventureworkslt tables are related?

935

What do you mean by cardinality?

906

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

What is the data type of time?

966

How to create a stored procedure with a statement block in ms sql server?

1076

Where views are stored in sql server?

996

How sql server enhances scalability of the database system?

1227

What is the New in SQL server 2008?

982

How to receive output values from stored procedures?

1151

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1147

What are magic tables in sql server?

1140

What is table value parameters (tvp)?

1108

How to recover from sql injection? : sql server security

1027

How to execute a sql statement using mssql_query()?

1056

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