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 verify a login name with sqlcmd tool?

1267

How to generate create table script on an existing table in ms sql server?

1197

How to replace null values in expressions using isnull()?

1152

How to set the current database in ms sql server?

1144

What are the requirements to use odbc connections in php scripts?

1159

What is a constant or literal in ms sql server?

1100

How extra digits are handled with numeric data type literals?

1034

What are ddl (data definition language) statements for tables in ms sql server?

1155

What happens when converting big values to integers?

1060

How to test values returned by a subquery with the in operator?

1255

How to apply filtering criteria at group level with the having clause in ms sql server?

1051

How to write character string constants or literals in ms sql server?

1068

How to test a dml trigger in ms sql server?

1117

What happens to a statement batch if there is a compilation error?

1012

How to create a new table in a given schema?

1255

Un-Answered Questions { SQL Server }

What is the difference between delete and truncate statements?

1131

What is the difference between local and global temporary tables?

1199

What is exclusive locks?

1014

Do you know what are the restrictions that views have to follow?

1129

What is difference between delete and truncate commands?

1175

What is the difference between a view and a stored procedure?

1092

What is log cache in sql server?

1100

Where in ms sql server is ’100’ equal to ‘0’?

1133

Explain the concept of view and Types of views in SQL server?

1037

What action plan is preferred if sql server is not responding?

1159

Do you think BCNF is better than 2NF & 3NF? Why?

1342

How to define output parameters in stored procedures?

1086

What is the syntax to execute the sys.dm_db_missing_index_details?

1077

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1021

How many types of triggers in sql server?

1094

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