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?

Difference between XP and Vista?

2 Answers   nvidia, TCS,

actually i want some sample test case which used in projects

1 Answers  

In the team both developers as well as testers will be included na,if so then the same TL will assign the work for testers also or else TL will be different for testers?

2 Answers  

how mapp the defect id in quality center?

0 Answers  

what is software testing

12 Answers   Wipro,

what is application state, base state, & call state.

1 Answers   TCS,

what is usecase testing? when it can be applied?

2 Answers  

Need Browser compatibility checklist? If any of you are having any doc or checklist on the same please share it with me.

5 Answers   Cap Gemini, Wipro,

test cases on orange hrm(( this is human resourse management system)

1 Answers   IBM,

what is meant by system test case

3 Answers   Accenture,

When will we write "use cases"? I mean that before writing test cases or after writing test cases? Please give me reply or send me answer to my mail id 'gopimanchella@gmail.com' Thanks in Advance.

4 Answers  

i have a little confusion about asp.net and vb.net is that the web applications called asp.net and windows application called as vb.net please guide if there is a difference between vb.net and windows application or what????I am just a beginner ..pls guide..

1 Answers