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 6454

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

3 8633

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

1 5589

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

TCS,

12 25729

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 6622

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

2 8542

how to know Who Is Blocking Your SQL Server?

4 12643

How to Get the last identity value used

4 8953

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

1 5355

How to Run a Query on a Remote SQL Server?

2 8488

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

1 4881

What's the purpose of Stored Procedure?

Wipro,

6 18306

What is normalization?

9 12941

What is a Stored Procedure?

8 12475

Can you give an example of Stored Procedure?

Wipro,

4 11294

Un-Answered Questions { SQL Server }

Name three of the features managed by the surface area configuration tool? : sql server security

990

What is a non clustered primary key?

925

What is apply operator in sql?

1011

Â Explain what is sql override for a source taLle in a mapping?

1012

How to filter records of table in SQL SERVER?

1086

How to count duplicated values in a column in ms sql server?

1092

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1033

How to update values in a table with update statements in ms sql server?

1013

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1263

What is the difference between local and global temporary tables?

1138

Explain the categories of stored procedure?

937

How to run sql server 2005 books online on your local system?

961

What is Replication?

1046

What is the difference between lock, block and deadlock? : sql server database administration

1045

Is the log file is a part of file group?

1039

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