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

How to view existing indexes on an given table using sp_help?

1058

How column data types are determined in a view?

904

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1002

What are the differences between char and varchar in ms sql server?

1003

How to bind a view to the schema of the underlying tables?

948

How real and float literal values are rounded?

1096

How to use subqueries with the in operators in ms sql server?

1015

How to receive returning result from a query?

1039

How to download and install sql server 2005 books online?

1089

How to override dml statements with triggers?

1077

How to create a simple table to test triggers in ms sql server?

916

How to test odbc dsn connection settings?

972

How to find out what is the default collation in a database?

1068

How to add a new dsn with the odbc driver for sql server?

1011

How to delete all rows with truncate table statement in ms sql server?

933

Un-Answered Questions { SQL Server }

What is the sql profiler?

901

what are candidate key, alternate key and composite key? : Sql server database administration

856

What is collation?

1101

What are approximate numeric data types in ms sql server?

1011

Will count(column) include columns with null values in its count?

1035

Write a program using SQL queries to find a unique entry in a table.

946

What are the steps to insert a table?

894

How optimize sql query with multiple joins in sql server?

830

How to generate create function script on an existing function?

1050

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1552

Do you know what is replace and stuff function in sql server?

943

What structure can you implement for the database to speed up table reads?

1159

Why use identity in sql server?

1012

Do you know what is difference between index seek vs. Index scan?

901

What is sql sandbox in sql server?

1149

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