11 lines
268 B
Transact-SQL
11 lines
268 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_character_block]
|
|
@character_id [uniqueidentifier]
|
|
as begin
|
|
set nocount on
|
|
update CharacterTable set
|
|
[Block_Type] = 4,
|
|
[Block_YN] = 'Y',
|
|
[IsTradeEnable] = 'N',
|
|
[IsMoveEnable] = 'Y'
|
|
where character_id = @character_id
|
|
end
|