| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How can your resolve deadlocks? | IBM | 3 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 3 |
| where do you use Isolations?give me some exmpale? | | 1 |
| how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables? | Lason | 1 |
| Difference between server.transfer and server.execute method? | | 1 |
| 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 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| What is a job? | | 3 |
| What is transcation?Plz give One example? | | 2 |
| Explain the new features of SQL server 2000? | | 1 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| table:employee
EID ENAME MID(manager ids)
101 rama null
102 sita 101
103 siva 101
104 ganesh 103
. . .
. . .
for 103 ID the manager ID is 101(RAMA) and for 104 manager
is SIVA
if i give employee id (EID) you have to tell the manager for
that EID write query?
eample:if i give 102 .The query output should be manager for
102 ID that it should print RAMA as output
| | 4 |
| What is the difference between a stored procedure and a user
defined function in sql server? | Millennium | 2 |
| What is row by row processing ? | | 1 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
