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?

1202

How column data types are determined in a view?

1005

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

1139

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

1120

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

1046

How real and float literal values are rounded?

1195

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

1123

How to receive returning result from a query?

1187

How to download and install sql server 2005 books online?

1270

How to override dml statements with triggers?

1272

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

1032

How to test odbc dsn connection settings?

1081

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

1177

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

1110

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

1045

Un-Answered Questions { SQL Server }

What does COMMIT command do?

1119

Can we check locks in database? If so, how can we do this lock check?

984

How to declare a cursor with "declare ... Cursor" in ms sql server?

1089

Explain the usage of floor function in sql server.

1018

What are built in functions?

1067

Which are the new data types introduced in sql server 2008?

925

What is query parameter in ssrs?

165

What is inline table-value user-defined function?

1162

How to find the source of a table in sql server?

1034

Do you know query execution plan?

1262

What are the instances when triggers are appropriate?

1017

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1108

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1297

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1070

What is 4nf in normalization form?

1060

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