这些有什么特别?
CREATE PROCEDURE ACCOUNT_LOGOUT
@AccountID varchar(21),
@Password varchar(13),
@a smallint OUTPUt,
@nRet smallint OUTPUT
as
BEGIN TRAN
DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
DELETE FROM CURRENTUSER WHERE strCharID = @AccountID
EXEC Rank_knights
COMMIT TRAN
BEGIN
set @a=1
set @nRet=1
RETURN
END
GO
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CREATE PROCEDURE CLEAR_REMAIN_CURRENTUSER
@accountid varchar(21)
AS
DELETE FROM CURRENTUSER where straccountid=@accountid
GO |