CREATE procedure WZ_GuildCreate
@GuildName nvarchar(8),
@Name nvarchar(10)
as
BEGIN
DECLARE @ErrorCode int
DECLARE @reset int
SET @ErrorCode = 0
SET XACT_ABORT OFF
Set nocount on
begin transaction
SELECT @reset=[Resets] from [Character] where [Name]=@Name
INSERT INTO Guild (G_Name, G_Master) valueS (@GuildName, @Name)
IF ( @reset > колко рес)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 1
END
IF ( @reset < колко рес ) IF ( @@Error <> 1 )
BEGIN
SET @ErrorCode = 1
END
IF ( @ErrorCode = 0 )
BEGIN
INSERT GuildMember (Name, G_Name, G_Level) values (@Name, @GuildName, 1)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 2
END
END
IF ( @ErrorCode <> 0 )
rollback transaction
ELSE
commit transaction
select @ErrorCode
Set nocount off
SET XACT_ABORT ON
END
GO
