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 5820

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

3 7814

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

1 4989

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

TCS,

12 22715

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 5974

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

2 7415

how to know Who Is Blocking Your SQL Server?

4 11368

How to Get the last identity value used

4 7738

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

1 4755

How to Run a Query on a Remote SQL Server?

2 7600

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

1 4259

What's the purpose of Stored Procedure?

Wipro,

6 16567

What is normalization?

9 10625

What is a Stored Procedure?

8 10526

Can you give an example of Stored Procedure?

Wipro,

4 10056


Un-Answered Questions { SQL Server }

Explain ranking functions?

705


How to add more data to the testing table in ms sql server?

643


How to use clusters?

618


We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

991


What is an indice?

666






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

579


How to download and install microsoft sql server management studio express?

657


Explain what is the purpose of sql profiler in sql server?

634


what are different types of backups available in sql server? : Sql server database administration

585


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

646


What happens if null values are involved in arithmetic operations?

673


What are different types of statement?

600


What is a deadlock and what is a live lock?

654


What is sql stored procedure?

685


What is snapshot parameter in ssrs?

116