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 6519

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

3 8749

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

1 5672

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

TCS,

12 26101

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 6709

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

2 8620

how to know Who Is Blocking Your SQL Server?

4 12787

How to Get the last identity value used

4 9083

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

1 5431

How to Run a Query on a Remote SQL Server?

2 8600

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

1 4942

What's the purpose of Stored Procedure?

Wipro,

6 18495

What is normalization?

9 13170

What is a Stored Procedure?

8 12710

Can you give an example of Stored Procedure?

Wipro,

4 11452

Un-Answered Questions { SQL Server }

Explain the difference between primary keys and foreign keys?

1095

Explain full-text query in sql server?

1050

Explain what are sparse columns?

1062

List few advantages of stored procedure.

1024

What is the need for group functions in sql?

1146

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3919

What is mean by dml?

1057

What are subquery and its properties?

1092

Explain ms sql server reporting services vs crystal reports?

968

what is the maximum size of a row? : Sql server database administration

1077

What is the default fill factor value?

1127

Tell me what is log shipping?

1029

Explain alternate key, candidate key and composite key in sql server?

946

Can you force a query to use a specific index?

985

What do you mean by stored techniques? How would we use it?

1079

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