seting a variale while a stored procedure is run

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

cy-dba SSCarpal Tunnel Points: 4179 More actions · Answer 1

Does your stored proc have an output parameter? If not, add one in the code to output the sum. Then execute as follows:

Declare @ret int

exec sp_SumTolat @ret output

select @ret

aayub SSC Veteran Points: 264 More actions · Answer 2

thanks for the help.

This is exactly what I required.

goodguy SSCertifiable Points: 5456 More actions · Answer 3

Asking as a Newbie, with no offence intended, wouldn't a function serve a better purpose to do the same thing?

Regards,

goodguy

Experience is a bad teacher whose exams precede its lessons

aayub SSC Veteran Points: 264 More actions · Answer 4

its nice that you asked.

Basically I was trying this first with a function but then found out that I cannot access a linked server from within a function.

So I had to take this stored procedure as an alternate.

Can i call a stored proceduere from within a function?

or can i call a databse in another server ?

or can i use open query in a function ?

Cookies on SQLServerCentral