Breaking News: Grepper is joining You.com. Read the official announcement!

sql server get stored procedure result into variable

Add Answer

Colorful Copperhead answered on July 17, 2023 Popularity 6/10 Helpfulness 2/10

Contents

answer sql server get stored procedure result into variable

More Related Answers

sql script get all stored procedures from database

create select stored procedure in sql server

stored procedure that selects in to a table

Execute stored procedure

stored procedure return value

sql server execute stored procedure with parameters

declare variable in stored procedure in sql server

Execute a stored procedure in another stored procedure in SQL server

sql stored procedure with table parameter

sql command to execute stored procedure with parameters c#

execute sql stored procedure in powershell

output parameter use with stored procedure

exec stored procedure with named parameters

ms sql server stored procedure output parameter

set a value by excuting stored procedure

stored procedure sql

sql server view stored procedure

stored procedure data to table

TSQL: How to execute a stored procedure

stored procedure with input and output parameters

sql trigger to call stored procedure with parameters

stored procedure sql

sql server execute stored procedure with table parameter

call stored procedure in c#

c# result set from stored procedure

fromsqlraw stored procedure with parameters

output keyword in stored procedure

Now I want for Sql server stored procedure

MYSQL stored procedure select from

sql server get stored procedure result into variable

Comment

0

#If it is a single integer value, you can use the return statement

 create proc myproc
 as 
 begin
     return 1
 end
 go
 declare @i int
 exec @i = myproc
#If you have a non integer value, or a number of scalar values, you can use output parameters

create proc myproc
  @a int output,
  @b varchar(50) output
as
begin
  select @a = 1, @b='hello'
end
go
declare @i int, @j varchar(50)
exec myproc @i output, @j output

#If you want to return a dataset, you can use insert exec

create proc myproc
as 
begin
     select name from sysobjects
end
go

declare @t table (name varchar(100))
insert @t (name)
exec myproc
#You can even return a cursor but that's just horrid so I shan't give an example :)

Popularity 6/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: get procedure sql sql-server

Share

Link to this answer
Share Copy Link

Colorful Copperhead

Contributed on Jul 17 2023

Colorful Copperhead

0 Answers Avg Quality 2/10

X

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

X

Grepper Account Login Required

Oops, You will need to install Grepper and log-in to perform this action.

Install Grepper Here