10 lines
207 B
Transact-SQL
10 lines
207 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_delete_mail]
|
|
@mail_id [uniqueidentifier]
|
|
|
|
as
|
|
set nocount on
|
|
|
|
delete dbo.MailTable where ID = @mail_id;
|
|
DELETE FROM [dbo].[N_MailItem] WHERE mail_uid = @mail_id;
|
|
|
|
return @@error
|