Answer / janaki.bayya

we are calling the stored procedure by using with exec
command or by calling from another program.
ex: Exec proc1 {pass parameters}
for a table class having the columns like cno number
cs char
ex: exec proce1 111,'abc'

Answer / 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.

Answer / sasidhar

@janaki
oh janaki thanks a lot , ur explanation is very much useful
to me
but i need more help from u
can i expect any test cases for this process and how to do
negative testing

Answer / janaki

hi sasidhar

depending on the project we will write testcases
for ex: in project class table is there
for that class table we have one stored procedure.

so we have to write the testcase like
input description:
"executing the stored procedure proce1 with input values
input data: (111,'abc',35)or take the input data from
database class table
expected results:the data shouble be inserted into class table

Answer / sasidhar

hi janaki my special thanks to you
tou have given quick replies to me

Do u know how to test proxy servers in manual testing?

Answer / sasidhar

hi janaki.bayya
thanks for ur reply
but i am unable to follow can u give step by step process
and can u clear what is exec command?

what is the difference b/w Priorty and severity in Bug Report

5 Answers   TCS,

1. What types of documents would you need for QA, QC, and Software Testing?

1 Answers  

How to do test if we have minimal or no documentation about the product?

4 Answers   3i Infotech,

you are testing with daily builds,you installed the latest build today and what will you do if the application shortcut is not launching?

2 Answers   Amazon,

how many modules in ur bank project? what functionalities r there?how did u check? could u plz expalin ur banking project?

0 Answers   Accenture,

What is V Model?

3 Answers  

Difference between the System Testing and System Integration Testing?

1 Answers   Wipro,

What is d diff. between d window based application and web based application testing?

2 Answers   Quest,

Give me Basics of these automation tools.. Q.T.P,q.c,Load runner.win runner on my gamil rachna.huda@gmail.com

1 Answers   IBM,

Hi, Friends, Can any one help me to------ how to write DataBase Test case or how to test database.I'm new in this field.I will do manual testing for a web side but don't know database testing.Plz Help me.Just alter or update the statement in db SQL like Update database db_name , Select * from table_name

0 Answers  

What is Wound Fixing?

0 Answers   Value Labs,

hi frnds, i m Aman.. i was asked some ques. in an interview which r concerned with Web based Testing.. ques were like, URL Tempory in testing, other was smthin like Gateway in testing?? plz tell me answers of these questions as i dont hav knwledge abt web based testing.. thnx in advance..

2 Answers   Net Solution,