advanced code snippet search

Posted By

kashif21 on 04/01/11


Tagged

sql function Value conversion


Versions (?)

SQL Value conversion function

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. ALTER FUNCTION [dbo].[fGetBuyerStatus] 
  2. (@StatusId INT)
  3. RETURNS VARCHAR(30)
  4. AS
  5. BEGIN
  6. DECLARE @RETURN VARCHAR(100)
  7. 	SELECT @RETURN=BuyerStatusName 
  8. 	FROM LUAssetBuyerStatus 
  9. 	WHERE BuyerStatusID = @StatusId
  10. RETURN @RETURN
  11. END

Report this snippet  

You need to login to post a comment.