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 6455

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

3 8637

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

1 5595

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

TCS,

12 25747

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 6624

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

2 8547

how to know Who Is Blocking Your SQL Server?

4 12648

How to Get the last identity value used

4 8959

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

1 5358

How to Run a Query on a Remote SQL Server?

2 8491

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

1 4887

What's the purpose of Stored Procedure?

Wipro,

6 18311

What is normalization?

9 12958

What is a Stored Procedure?

8 12491

Can you give an example of Stored Procedure?

Wipro,

4 11300

Un-Answered Questions { SQL Server }

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

906

In what three ways is the return statement used in a stored procedure?

1008

Where can you add custom error messages to sql server?

1125

Explain few examples of RDBMS?

1041

How to encrypt Strored Procedure in SQL SERVER?

1168

What is the difference between upgrade and migration in sql server?

1091

How to copy the tables, schema and views from one sql server to another?

1047

What is difference between join and natural join?

972

What is mscorsvw.exe - process - microsoft .net framework ngen?

955

Define msdb database?

1023

Can a table be created inside a trigger?

968

How can you insert values in multiple rows using one Insert statement?

1102

What is change data capture (cdc) in sql server 2008?

1024

Explain what is the difference between a local and a global temporary table?

1003

What is sql server replication? : sql server replication

991

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