1
DECLARE @s datetime
2DECLARE @e datetime
3DECLARE @body AS varchar(8000)
4
5SET @s = DATEADD(mm,DATEDIFF(mm,'1900-1-1',getdate())-1,'1900-1-1')
6SET @e = DATEADD(mm,DATEDIFF(mm,'1900-1-1',getdate()),'1900-1-1')-.00001
7
8INSERT INTO [IP].DB.dbo.table
9SELECT *
10FROM table
11WHERE condition
12
13
14-- 发邮件
15SET @body = 'Text'+ CHAR(13)
16SET @body = @body + '如果数据有问题,请联系系统管理员终止事务'+ CHAR(13)
17SET @body = @body + '相关SQL'+ CHAR(13)
18SET @body = @body + '-------------------------------------------------'+ CHAR(13)
19SET @body = @body + 'SQL'+ CHAR(13)
20EXEC usp_SendMail 'sun_ming_888@163.com','数据导出完毕（系统邮件）',@body
DECLARE @s datetime2
DECLARE @e datetime3
DECLARE @body AS varchar(8000)4
5
SET @s = DATEADD(mm,DATEDIFF(mm,'1900-1-1',getdate())-1,'1900-1-1')6
SET @e = DATEADD(mm,DATEDIFF(mm,'1900-1-1',getdate()),'1900-1-1')-.000017
8
INSERT INTO [IP].DB.dbo.table9
SELECT *10
FROM table11
WHERE condition12
13
14
-- 发邮件15
SET @body = 'Text'+ CHAR(13)16
SET @body = @body + '如果数据有问题,请联系系统管理员终止事务'+ CHAR(13)17
SET @body = @body + '相关SQL'+ CHAR(13)18
SET @body = @body + '-------------------------------------------------'+ CHAR(13)19
SET @body = @body + 'SQL'+ CHAR(13)20
EXEC usp_SendMail 'sun_ming_888@163.com','数据导出完毕（系统邮件）',@body
浙公网安备 33010602011771号