Posted By

kashif21 on 04/01/11


Tagged

sql function Value conversion


Versions (?)

SQL Value conversion function


 / Published in: SQL
 

  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.