The grammar is following,
eg:
declare @result int
exec @result=sp_userTest
select @result
//statements: sp_userTest is a procedure,which is following
create procedure sp_userTest
As
Select * from autolink_user
Return 1
eg:
declare @result int
exec @result=sp_userTest
select @result
//statements: sp_userTest is a procedure,which is following
create procedure sp_userTest
As
Select * from autolink_user
Return 1