Anonymous

/****** Object:  Stored Procedure dbo.lin_AdenaChange    Script Date: 2003-09-20 &#50724;&#51204; 11:51:56 ******//********************************************lin_AdenaChange	change adena and return result amountINPUT	@char_id	INT,	@price	 	INTOUTPUT	adena id		INT,	amount		INTreturnmade by	carrotdate	2002-04-22********************************************/CREATE PROCEDURE [DBO].[lin_AdenaChange](	@char_id	INT,	@price	 	INT)ASSET NOCOUNT ONDECLARE @nAmount	INTSET @nAmount = NULLSELECT @nAmount = amount FROM user_item WHERE char_id = @char_id AND item_type = 57IF @nAmount IS NULL	BEGIN		SELECT -1, -1	ENDELSE IF @nAmount + @price < 0	BEGIN		SELECT -1, -1	ENDELSE	BEGIN		UPDATE user_item SET amount = amount + @price WHERE char_id = @char_id AND item_type = 57 AND warehouse = 0		SELECT item_id, amount FROM user_item WHERE char_id = @char_id AND item_type = 57 AND warehouse = 0	ENDGO