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 provide default values to function parameters?

1219

How to use transact-sql statements to access the database engine?

1122

How to create new table with "create table" statements?

1192

How to connect php with different port numbers?

1147

How to fetch the next row from a cursor with a "fetch" statement?

1109

How to divide query output into multiple groups with the group by clause in ms sql server?

1085

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

1137

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

1141

How to drop existing indexes in ms sql server?

1127

How to concatenate two binary strings together?

1174

How to defragment table indexes?

1036

Is the primary key column of a table an index in ms sql server?

1002

How to generate create procedure script on an existing stored procedure?

1061

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

1156

How to concatenate two character strings together?

1166

Un-Answered Questions { SQL Server }

Tell me about the approaches which you used to counter the DI problems.

1427

can an order by clause be used in a creation of a view?

1237

What command is used to create a database in the sql server and how?

1240

What is a filestream?

1045

Can a unique index be created on a column, which contains null?

966

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1188

What is transactional replication?

1020

Differentiate between SQL and ORACLE joins and write their syntax.

1071

Tell me when is the update_statistics command used?

1198

What is a transact-sql statement batch in ms sql server?

1068

How do I shrink an ldf file?

1037

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1114

How will you hide an attribute? : sql server analysis services, ssas

1010

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

958

What is collation?

1192

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