How i can OUTPUT in Stored Proc

yoord · July 19th, 2004, 02:00 PM

i want to examine such this condition in my SP that
insert two values into a table and output some values by applying select clauses and put values in the ouput parameters i dont know if i haveto present values to this parameters or it is option becuase i dont like to give any values to this parameters and only i like to using this for output values i use such this code.

Quote:

quote:create proc ins_nazar6(@q1_value tinyint,@more ntext,@bad int=null output,@mid int=null output)

Quote:

as
begin
insert into nazar_sanji(q1_value,more) values(@q1_value,@more)
end
begin
select @mid=count(*) from nazar_sanji where q1_value=1
end
begin
select @bad=count(*) from nazar_sanji where q1_value=1
end

is it correct

bmains · July 19th, 2004, 03:01 PM

Hello,

You have a default set on them of null. This value will be returned if no value is provided from the select.

From what I can tell, I don't see any syntax issues...

Is that what you were asking?

Brian

yoord · July 19th, 2004, 03:11 PM

hi brian thanx for your reply.
if use this SP like this and remove all null options is would it work again.
i like call this SP Like this

Quote:

quote:sp_in_nazar6 2,'test insert'

and i like it insert this values and return(OUTOUTs) For this 2 OUTOUTs
i dont know if this SP Yet Satisfies my goals.
Thanx In Advance.
YoOrD