| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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
| | 5 |
| How can your resolve deadlocks? | IBM | 3 |
| select empid empname from employee
What is the result for the about query? | | 4 |
| i want table name basis on column name. | | 5 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 4 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| Is trigger fired implicitely? | | 2 |
| Which virtual table does a trigger use? | | 3 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 2 |
| How can u convert the Date to String? | TCS | 4 |
| What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning | TCS | 2 |
| How do you simulate a deadlock for testing purposes | | 1 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| what are the new features of sql server 2005? | HP | 5 |
| Which is best Subquery (or) joins in sql server? explain why | | 2 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| what is a cursor and what is its use? | | 1 |
| there is a table having two columns no and name
and the data is
1 A
2 B
3 C
write a query that will result a horizontal output
A,B,C
| vsworx | 7 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
