Advanced Search

SQL Value conversion function

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

Expand | Embed | Plain Text

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.