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

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 6376

How do I compare two values when one value(data type) is char and the other is an integer?

3 8498

What are the pros and cons of creating extended stored procedures?

1 5510

Is it possible to delete duplicate rows in a table without using a temporary table ?

TCS,

12 25301

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 6533

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 8421

how to know Who Is Blocking Your SQL Server?

4 12467

How to Get the last identity value used

4 8794

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 5286

How to Run a Query on a Remote SQL Server?

2 8372

How to Generate a Series of Random Integers With T-SQL?

1 4814

What's the purpose of Stored Procedure?

Wipro,

6 18073

What is normalization?

9 12632

What is a Stored Procedure?

8 12149

Can you give an example of Stored Procedure?

Wipro,

4 11114

Un-Answered Questions { SQL Server }

What are drilldown reports?

142

How to define output parameters in stored procedures?

970

What gets stored inside msdb database?

1201

What is the difference between DataRow.Delete() and DataRow.Remove()?

1173

What are the differences between char and nchar in ms sql server?

1019

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

141

What are indexes in ms sql server?

1004

What is an execution plan?

1068

Explain the relational database management system (rdbms)?

1029

What is difference between equi join and natural join?

975

What is a scheduled job or what is a scheduled task?

919

What are the different authentication modes in sql server? How can it be changed?

1031

how many layers of tcp/ip protocol combined of? : Sql server database administration

945

What are binary string data types in ms sql server?

1191

What is raid, and how it can influence database performance?

1017

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