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