Advanced Search

Return to Snippet

Revision: 43876
at April 1, 2011 21:50 by kashif21
Initial Code 
ALTER FUNCTION [dbo].[fGetBuyerStatus] 
(@StatusId INT)
RETURNS VARCHAR(30)
AS
BEGIN
DECLARE @Return VARCHAR(100)
	SELECT @Return=BuyerStatusName 
	FROM LUAssetBuyerStatus 
	WHERE BuyerStatusID = @StatusId
RETURN @Return
END
Initial URL 









Initial Description














Initial Title





SQL Value conversion function









Initial Tags





sql, function









Initial Language





SQL