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 4211

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

3 5839

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

1 3763

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


12 14050

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 4759

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

2 5502

how to know Who Is Blocking Your SQL Server?

4 8531

How to Get the last identity value used

4 5161

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

1 3469

How to Run a Query on a Remote SQL Server?

2 5971

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

1 2829

What's the purpose of Stored Procedure?


6 11432

What is normalization?

9 6481

What is a Stored Procedure?

8 6195

Can you give an example of Stored Procedure?

4 6751

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

your distribution database is full what will u do


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


what are the Prerequisites for Replication?


what exactly sql injuction.how to overcome.....


how to use DTS package in 2000,2005,2008 in sql server


What are the dis_advantages of stored procedures, triggers, indexes?


Does any body please help me what question's have asked for SSRS in the interview?


How do use Having,Group by,Group function in SQL?


what is difference between view and Dip.


New concepts of sql server 2005 use in your project.


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram


Tell about MOM Tool(Microsoft Operator Manager)?