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
What are the cases why parameterization is necessary when load testing the Web server and the database server?
What is data flow diagram?
discuss black box and white box testing is not widely used if you disagree tell me why?
1.What is bidirectional traceability ??? and how it is implemented? 2.What is Automation Test frame work ? 3. Define the components present in test strategy? 4. Define the components present in test plan? 5. Have u written Test plan ?…. thank u!plz reply........
What is a bug triage?
Hi, This is vkram.I had completed my B.E in May 2005 & currently i am undergoing Testing Course. I want to join as a Fresher in any MNC. What should I tell why u r coming to testing field & what u did this 2 years?
What is mean by multi-threading testing?
what are the possible test cases for online jobs search portal..if its a job seeker module and any 1 if u had worked on this proj pls share the bugs with sev and priority pls frends i need replies for these queries ..thanks in advance
can u plz give an example for regression testing with example.
can anyone tell me the scenarios for online banking transaction ?
Hi Friends, I've to submit a presentation in my office about "Different bug tracking tools" ? Where can i find (or any site) the templates for the bug tracking tools.
Functional and Integration test scenarios for actitime application
how to creat 2 test plan in 2 different environment exp:tour and travel
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?
Hi,all i have a desktop App. which have a feature, It's a demo version if u want full version then u have to perches it. Pls give me some idea ASAP how can i break the App.