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 create “alternate row colour”?

146

How to create percentile function?

151

How to make conditional sum in ssrs?

177

how you can deploy an ssrs report?

178

Can I disable or restrict ssrs export formats (rendering formats)?

150

How to create “dependant” parameter “make, model, year”

131

Can sub report data source be different from that of the parent report?

143

How to create median function?

164

Sql server reporting services vs. Crystal reports.

131

When I run the sql server 2000 setup, it just hangs. What do I do?

1078

Which tcp/ip port does sql server run on? How can it be changed?

1033

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1016

What is a file group?

1085

Does order by actually change the order of the data in the tables or does it just change the output?

1138

What is the definition for sql server 2000?

1084

Un-Answered Questions { SQL Server }

What is the difference between for auto and for nested?

998

What are the differences between stored procedure and view in sql server?

1241

Explain what is use of dbcc commands?

1052

How to convert numeric expression data types by assignment operations?

1067

Do you know what is blocking?

948

What is the use of keyword with encryption.

1026

What is difference between sql and sql server?

992

How many null values we can have in a unique key field in sql server?

953

How do I run sql server 2014?

981

How to check parameter value in stored procedure sql server?

968

How to transfer data from a cursor to variables with a "fetch" statement?

1091

State a few properties of relational databases?

1120

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1018

Why should you use or avoid select * statements?

1020

Why do we partition data?

1025

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