Answer Posted / janaki

hi this is janaki
i will tell u with example

we have class table with columns as
create table class
( cn number,
cname varchar2(15),
csize number):
class table created.
now we create a procedure for this table

create procedure proce1(@cno,@cn,@cs)
as
begin
if @cs>20
begin
insert into class values(@cno,@cn,@cs)
end
else
print 'csize should be greater than 20'
end

--procedure created.
we can make use of the 'exec(execute) command to call a
procedure by passing the parameters.

Exec proc1 111,'abc',35
these values to be inserted in class table.

this is the way we have to test stored procedures.ok.
Janaki.

tell me some major and minor defects in ur net banking project?

3630

---

Can anyone tell me, What is wound fixing?

2592

---

What is showstopper defect?

1204

---

What is common interface?

1968

---

What is strategy to be followed for execution of 500 Test Cases in One day. If only 1 Resource is available.

1957

---

What are the cases why parameterization is necessary when load testing the Web server and the database server?

2199

---

What is the difference between functional testing and integration testing?

1330

---

What is regression testing? When to apply it?

1145

---

can any one post the format of tracebility martrix Plz...... Maid Id: sandhya.shyamala@yahoo.com

2260

---

Can you explain regression testing and confirmation testing?

1147

---

What is pesticide paradox? How to overcome it?

1309

---

i heard that mainframe testing is diff from other environments & has lot of keyboard input????pl clarify my doubt & let me know in what way its diff??

2111

---

can anyone help me regarding testing patterns?

2023

---

functional testing and usability testing test cases for transfer funds...

1773

---

Explain test metric and the information it provides.

1135

---