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?

1135

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

1067

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

1107

How to connect php with different port numbers?

1085

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

1073

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

1037

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

1079

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

1097

How to drop existing indexes in ms sql server?

1072

How to concatenate two binary strings together?

1123

How to defragment table indexes?

990

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

962

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

1009

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

1076

How to concatenate two character strings together?

1121

Un-Answered Questions { SQL Server }

How to identify current user in ssrs report?

403

What are unicode character string data types in ms sql server?

1254

What is difference between aggregate and analytic function?

932

Do you know sql server 2008 introduces automatic auditing?

980

Is it possible to update the views? If yes, how, if not, why?

1029

Explain about Joins?

988

What do you mean by tablesample?

1079

What happens if null values are involved in bitwise operations?

1026

Tell about MOM Tool(Microsoft Operator Manager)?

1914

Explain encryption of entire databases without the need for application changes in sql server 2008?

1040

How to select some specific columns from a table in a query in ms sql server?

1005

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2026

Can you explain the disadvantages/limitation of the cursor?

988

How do you use a subquery to find records that exist in one table and do not exist in another?

1049

What are SSL and TSL protocols?

985

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