14 lines
278 B
Transact-SQL
14 lines
278 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_clear_mail]
|
|
@mail_id [uniqueidentifier],
|
|
@item_id_00 [uniqueidentifier],
|
|
@item_id_01 [uniqueidentifier],
|
|
@item_id_02 [uniqueidentifier]
|
|
|
|
as
|
|
set nocount on
|
|
|
|
update dbo.MailTable set
|
|
[gold] = 0
|
|
where ID = @mail_id;
|
|
|
|
return @@error
|