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?

1187

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

1071

How to create user defined functions with parameters?

1292

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?

1237

How to configure odbc dsn with different port numbers?

1151

What happens if null values are involved in bitwise operations?

1076

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

1071

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

1186

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?

1104

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

1428

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

963

Un-Answered Questions { SQL Server }

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1065

What is sub-query in sql server?

1257

How do I shrink an ldf file?

1034

Explain view in sql server?

1086

Explain full-text indexing?

1042

How you provide security to cube? : sql server analysis services, ssas

1006

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4453

Write a program using SQL queries to find a unique entry in a table.

1043

What is an expression in ms sql server?

1139

Call by value and call by reference in procedure and function, with NOCOPY.

1345

How to include text values in sql statements?

1094

Explain datetime2 data type in sal server 2008?

949

What are commit and rollback in sql?

1168

What is factless fact table? : sql server analysis services, ssas

1094

What is a periodical index?

973

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