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 6442

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

3 8603

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

1 5573

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

TCS,

12 25671

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 6607

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

2 8524

how to know Who Is Blocking Your SQL Server?

4 12613

How to Get the last identity value used

4 8932

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

1 5336

How to Run a Query on a Remote SQL Server?

2 8468

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

1 4868

What's the purpose of Stored Procedure?

Wipro,

6 18275

What is normalization?

9 12892

What is a Stored Procedure?

8 12427

Can you give an example of Stored Procedure?

Wipro,

4 11261

Un-Answered Questions { SQL Server }

What is merge replication?

1097

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

955

What command would you use to create an index?

1047

What is the difference between inner join and equi join?

983

What are the difficulties faced in cube development? : sql server analysis services, ssas

1031

Which command is used for user defined error messages?

1057

Explain the first normal form(1nf)?

1016

What is the maximum size of a row in sql server?

958

How to set a database state to offline in ms sql server?

1035

What is the maximum row of a size?

1010

How to concatenate two strings in SQL Server.

1145

What do you understand by mirroring?

991

Give an example of SQL injection attack ?

1000

How to create a trigger for insert only?

1030

What is DCL?

1043

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