Stored procedure, Trigger and Function in MS SqlServer


## Simple Function

CREATE FUNCTION GetName (@SID int)
RETURNS varchar(30) AS
BEGIN
declare @sName varchar(30)
select @sName=SName from tblTest where SID= @sID
return @sName
END

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s