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

Why people hate cursor?

1202

Find first and last day of current month in sql server

1080

How to handle error or exception in sql?

1036

How to create function without parameter in sql server?

1107

How to select true false based on column value in sql server?

1082

what's new in sql server 2016?

1003

What is @@error in sql?

1108

Why use triggers?

1068

What is store procedure?

1113

What is @@rowcount in sql?

1056

What is a functions and types in sql server?

1147

When you use @@error and try-catch?

1091

What is store procedure? How do they work?

1068

What is sql view?

1117

How to change server name in sql server?

1252

Un-Answered Questions { SQL Server }

What is replication and database mirroring?

1086

How to provide values to stored procedure parameters in ms sql server?

1097

What are different types of join?

1375

How to create median function?

172

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1249

How will you hide an attribute? : sql server analysis services, ssas

1010

Why are sql functions used?

1182

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1199

How to list all triggers in the database with sys.triggers in ms sql server?

1125

Write an sql query to find first weekday of the month?

975

What is proper subset of candidate key?

1041

What are synonyms?

1015

What is normalization of database?

1177

Define synonym?

1222

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

1150

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