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.

what risks do u faced u r projest how do you solve

2133

---

What is build interval period?

2365

---

What is Independant Testing? When and where this type of testing will be performed?

2016

---

what is date field test case

1997

---

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

3637

---

How can data caching have a negative effect on load testing results?

2998

---

What is Test methodology, Testing type , Testing approach, Testing technique & Testing methods. Explain with example.

1976

---

Login screen with Username, Password input fields,remember me check box,sign in and reset button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.

2857

---

What were the major challenges u faced while testing

2520

---

What are the main key components in web applications?

1239

---

i need manual testing interview questions for 2+ experience plzz help me..

4574

---

what kind of testing have u done?

2017

---

What ishigh severity, low priority bug?

1141

---

Test approach to windows scheduler?

2188

---

In cycle 1 we have 100 test cases out of which 95 test cases are PASS and 5 test cases are FAIL. So in cycle 2 how many test cases performed as a part of regression testing?

1651

---