27 lines
601 B
Transact-SQL
27 lines
601 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_guild_permission]
|
|
@guild_id [uniqueidentifier],
|
|
@permission00 int,
|
|
@permission01 int,
|
|
@permission02 int,
|
|
@permission03 int,
|
|
@permission04 int,
|
|
@permission05 int,
|
|
@permission06 int,
|
|
@permission07 int
|
|
as
|
|
set nocount on
|
|
|
|
update dbo.GuildTable set
|
|
|
|
permission01 = @permission00,
|
|
permission02 = @permission01,
|
|
permission03 = @permission02,
|
|
permission04 = @permission03,
|
|
permission05 = @permission04,
|
|
permission06 = @permission05,
|
|
permission07 = @permission06,
|
|
permission08 = @permission07
|
|
|
|
where guild_id = @guild_id
|
|
|
|
return @@error
|