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?

1053

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

999

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

998

How to connect php with different port numbers?

1003

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

1018

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

964

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

1013

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

1024

How to drop existing indexes in ms sql server?

1015

How to concatenate two binary strings together?

1050

How to defragment table indexes?

932

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

920

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

940

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

1001

How to concatenate two character strings together?

1058

Un-Answered Questions { SQL Server }

which table keeps the locking information? : Sql server administration

1013

Is it possible to call a stored procedure within a stored procedure?

917

What is sql server query analyzer?

967

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2707

What do you mean by normalisation?

964

What is command parameter in ssrs?

153

What is code near application topology?

271

What is the need for group functions in sql?

1009

How do you size a resultset?

878

Can we perform backup restore operation on tempdb?

955

What is the synonym of join?

896

What are the functions in sql server?

903

Can we install sql server 2016 on windows 7?

1074

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

991

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

184

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