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 are you getting errors when creating a new odbc dsn?

1171

What happens if null values are involved in string operations?

921

How to test subquery results with the exists operator?

1039

How to download and install the scaled-down database adventureworkslt?

956

How to connect to a sql server using odbc_connect()?

1096

How to select an exiting database using mssql_select_db()?

914

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1037

What causes index fragmentation?

941

How to modify the underlying query of an existing view?

937

How to end a stored procedure properly in ms sql server?

1020

How to view existing indexes on an given table using sys.indexes?

1038

How to convert numeric expression data types by assignment operations?

1007

How to use union to merge outputs from two queries together in ms sql server?

1011

How to create prepared statements using odbc_prepare()?

1000

How to skip remaining statements in a loop block using continue statements?

935

Un-Answered Questions { SQL Server }

What is the federation in sql azure?

What is the default value of an integer data type in sql server 2005?

912

What is the difference between a function and a trigger?

1014

List the types of recovery model available in sql server?

873

How can you list all the table constraints in a database?

887

What is the contrast between sql and mysql?

1051

How to list all user names in a database?

1008

What is partition, how will you implement it? : sql server analysis services, ssas

994

How to write a query with a right outer join in ms sql server?

873

Give me any three differences between Truncate and Delete.

1047

What is the difference between Normalization and De-normalization?

1031

Explain what is meant by replication of database?

961

What are the three different part of rdl file explain them?

253

What is the architecture of ms sql reporting service?

926

How do you check sql server is up and running?

935

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