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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
When do we perform smoke testing?
what is dib format?
what will be verification and validation test cases for yahoo login page (only functional test cases)? Please explain in details.
Can any one give a summary of testing a territory management system? what would be the test scenarios, few test cases. how it works.
What is stub?
can any one explain me briefly erp pharma project including all modules,like how to tell this project in interview in terms of s/w testing
What do you do (with the project tasks) when the schedule fails?
What is coverage and what are the different types of coverage techniques?
What is mean by multi-threading testing?
Hi, can any tell how a tester can be judged? i have to interview a tester, how should i judge whether he has a justified experience or not? how a person with 3 years of experience in manual testing can be judge?
I have 2 years of exp. in testing and looking for a change if any body knows, about any vacancy in testing then plz contact me on deepti_ac@yahoo.co.in
Describe any bug you remember. Plz Give some real examples
Scenario-based testing Option 1 concentrates on actor and software interaction Option 2 misses errors in specifications Option 3 misses errors in subsystem interactions Option 4 Both 1 abd 2
What is back to back testing?
What is boundary value testing? Give an example.
