Mine

--GoatCheezCREATE PROCEDURE UPDATE_CHARBAN@nRet		smallint OUTPUT, @CharID		char(21),ASDECLARE @BanCount int, @IpAddress char(50), @TodaysDate dateSET @TodaysDate = CURRENT_TIMESTAMPSET @BanCount = 0SELECT @IpAddress=strClientIP FROM CURRENTUSER WHERE strCharID=@CharIDSELECT @BanCount=IF @@ERROR <> 0BEGIN	 	ROLLBACK TRAN 	SET @nRet =  1	RETURNENDCOMMIT TRANSET @nRet =  0GO