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 list all stored procedures in the current database using ms sql server?

1189

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1072

How to create user defined functions with parameters?

1293

How to create a view using data from another view?

994

How to drop an existing user defined function in ms sql server?

1063

How to execute the cursor queries with "open" statements?

1238

How to configure odbc dsn with different port numbers?

1151

What happens if null values are involved in bitwise operations?

1077

How to delete multiple rows with one delete statement in ms sql server?

1072

How to create a view on an existing table in ms sql server?

1188

How to change the password of a login name in ms sql server?

1057

Why I am getting this error when dropping a database in ms sql server?

1117

Why I can not enter 0.001 second in date and time literals in ms sql server?

1105

How to loop through the result set with @@fetch_status?

1430

What is the impact on other user sessions when creating indexes?

963

Un-Answered Questions { SQL Server }

What is the temp table?

974

What is the difference between a stored procedure and a user defined function?

1062

What are statistics?

1050

What is 2nf in normalization?

1054

Do you know what is rank function?

1125

What is the difference between DATETIME2 and DATETIME?

1125

How to call stored procedure using http soap?

1128

What are different types of database indexes?

1168

Can we add an identity column to decimal datatype?

1041

what is the information that can be stored inside a bit column? : Sql server database administration

1009

how to create “alternate row colour”?

152

What is a trigger and types of a trigger?

1026

Mention the different types of replication in sql server.

1069

What is correlated subquery in sql server?

1122

What are the types of user defined functions in sql server?

1093

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