how to call a procedure with output parameter in sql server 2008

Posted by Shanky11 under Sql Server on 7/4/2013 | Points: 10 | Views : 1112 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

table column is
studentid sname firstname lastname emailid

i have created a procedure
create procedure getstudentname
(
@studentid int,
@studentname VARCHAR(200) OUT
)
AS
BEGIN
SELECT @studentname= Firstname+' '+Lastname FROM student_demo WHERE studentid=@studentid
END
now how can i call this procedure in sql

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Pandians on: 7/4/2013 [Member] [MVP] Silver | Points: 25

0	Check it Out! Once created the Procedure DECLARE @studentname_Out VARCHAR(200) EXEC getstudentname 101,@studentname = @studentname_Out SELECT @studentname_Out [Student Name] GO Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts