Difference between Inner vs outer joins?

0 Answers  

---

What is the difference between a local and a global temporary table?

0 Answers  

---

what is the cursor life span?

5 Answers   Evalueserve, HG,

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

---

Mention the command used to rename the database.

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

Tell me what is log shipping?

0 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

7 Answers  

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

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

0 Answers  

---

What is the use of DBCC commands?

4 Answers   NA,

---