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