15 lines
299 B
Transact-SQL
15 lines
299 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_ban_memo]
|
|
@character_id [uniqueidentifier],
|
|
@ban_id [uniqueidentifier],
|
|
@ban_memo nvarchar(32)
|
|
|
|
as
|
|
set nocount on
|
|
|
|
update dbo.FriendTableEx set
|
|
|
|
CutReason = @ban_memo
|
|
|
|
where character_id = @character_id and friend_id = @ban_id
|
|
|
|
return @@error
|