how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What are the results of running this script?

0 Answers  

---

Which tcl commands are available on the sql server?

0 Answers  

---

Where can you find the error log information? : sql server database administration

0 Answers  

---

What is a sql join?

0 Answers  

---

What is the stuff?

0 Answers  

---

What is left outer join in sql server joins?

0 Answers  

---

Why people hate cursor?

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  

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---