SQL Value conversion function


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.