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?

1133

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

1024

How to create user defined functions with parameters?

1235

How to create a view using data from another view?

948

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

1025

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

1180

How to configure odbc dsn with different port numbers?

1087

What happens if null values are involved in bitwise operations?

1026

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

1024

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

1128

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

1013

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

1072

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

1065

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

1349

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

927

Un-Answered Questions { SQL Server }

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

945

Why use “pivot” in sql server?

1119

What is the Disadvantage of indexed sequential file.

1084

How to modify an existing stored procedure in ms sql server?

1079

What are the different kinds of ssrs reports?

214

Explain the flow of creating a cube? : sql server analysis services, ssas

1050

Can a table be moved to different filegroup?

976

Which joins are sql server default?

1011

How is a full-text index updated?

954

How you can find out if an index is useful to the optimizer?

939

Mention the differences between substr and charindex in sql server.

1050

Explain system views?

1086

Explain the concepts and capabilities of sql server?

976

How to convert numeric expression data types by assignment operations?

1081

Delete duplicate rows without using rowid.

1532

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