بخصوص ال union

[sobhe_wizard]

دلوقتي في مشكله الناس في السيرفر مش عارفه تعمل union بيعملو كل حاجه و لما بيدوسو OK علشان يقبلو ال union مفيش حاجه بتحصل

[MrGame3]

جرب ال كويري ده

USE [SRO_VT_SHARD]

GO
/****** Object: StoredProcedure [dbo].[_Guild_Create] Script Date: 14.06.2014 16:53:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




--
ALTER PROCEDURE [dbo].[_Guild_Create]
@guildName varchar(64),
@CreaterID int
as
if (exists (select id from _Guild where Name = @guildName))
begin
return -1000
end
if (exists (select CharID from _GuildMember where CharID = @CreaterID))
begin
return -1001
end
begin transaction

declare @guildID int
declare @FoundationDate smalldatetime

set @FoundationDate = GetDate()
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_1', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_2', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_3', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_4', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_5', 1, 0, @FoundationDate,0,0)


insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName, 5, 0, @FoundationDate,0,0)
set @guildID = @@identity

if (@@error <> 0 or @@rowcount = 0 or @guildID = 0)
begin
rollback transaction
return -5
end


--길드ى‍¥ى‌€ يچ¼ë¯¸ى…کى‌´ 0xffffffff !!
declare @rvalue int
exec @rvalue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end

-- 길드 ى°½ê³*를 ىƒ‌ى„±ي•کى‍گ
exec @rvalue = _Guild_CreateChest_NoTX @guildID
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end


commit transaction
return @guildID

[Dev.Ri3o]

اعمل دول

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AllianceCreate] Script Date: 2/2/2017 1:40:49 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_AllianceCreate]

@CreatorGuildID int,
@FirstAllyGuildID int
AS

set xact_abort on
begin transaction
declare @AllianceID int
set @AllianceID = 0
Insert into _AlliedClans values(@CreatorGuildID,@FirstAllyGuildID,0,0,0,0,0 ,0,GetDate(),0,0)
if (@@error <> 0 or @@rowcount = 0)
begin
rollback transaction
return -1
end
set @AllianceID = @@identity
if( @AllianceID = 0 )
begin
rollback transaction
return -2
end
update _Guild set Alliance = @AllianceID where id in (@CreatorGuildID, @FirstAllyGuildID)
if( @@error <> 0 or @@rowcount <> 2 )
begin
rollback transaction
return -3
end
commit transaction
return @AllianceID



USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AllianceRemove] Script Date: 2/2/2017 1:41:44 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------
ALTER PROCEDURE [dbo].[_AllianceRemove]
@AllianceID int
AS
if( not exists( select id from _AlliedClans where id = @AllianceID ) )
begin
return 0
end
set xact_abort on
begin transaction
--ى‌¼ë‹¨ ى†Œى†چ 길드부ي„° ê°•ى*œ يƒˆي‡´ë‹¤!
update _Guild set Alliance = 0 where Alliance = @AllianceID
if (@@error <> 0 or @@rowcount = 0)
begin
rollback transaction
return 0
end
--ëڈ™ë§¹ ë‚*린다
delete _AlliedClans where id = @AllianceID
if (@@error <> 0 or @@rowcount = 0)
begin
rollback transaction
return 0
end
commit transaction
return 1

[sobhe_wizard]

تم الحل شكرا ليكو
#يغلق

[Dev.Ri3o]

##