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.

Hi,Please can any one tell me about SAP Testing concepts.

2010

---

How do you estimate white box testing?

1112

---

Which are the standards for software test plans?

1199

---

what are questions asked in TCS for database tester (sqlserver)?ay idea

2936

---

can anyone help me in getting unix on manual testing i.e can u forward material & web sites to my mail id (suresh_57599@yahoo.com) to understand how the work flow working on manual testing on unix and the contents.plzzzzzzzz help me its urgent.

1911

---

uses of checklist

1932

---

Hi everyone, My name is Salil Mishra. I am having 1.7 years of experience in manual testing. But as i m 2008 passout, there are limited position for me in the companies. Please help me out in getting a good job guys..I f you find something then please mail me at salilmishra29@gmail.com

1947

---

What are the tasks of test closure activities in software testing?

1130

---

What are drawbacks in system development life cycle

2219

---

How is ‘build’ different from ‘release’?

1153

---

Explain the procedure for manual testing.

1141

---

What are the different levels of manual testing?

1189

---

What is Independent Testing?

2060

---

Hi there Does anybody can respond to my Questions? Is some one there to answer my Questions posted in Software testing category.pls E-mail to sunitht27@yahoo.com

2156

---

Why testers wil prepare useracceptance testcases,system testcases and integration testcases,What is the differenece between all this test cases

2083

---