请教: 如何突破存储过程中varchar(8000)的限制?
请教: 如何突破存储过程中varchar(8000)的限制?
DECLARE @source varchar(8000)
DECLARE @description varchar(8000)
DECLARE @Temp varchar(1000)
DECLARE @cmd varchar(1000)
DECLARE @object int
DECLARE @hr int
select @temp='sunrise_chen@msn.com'
select @cmd = 'LargeMessage from t_MailContent where id=1'
EXEC @hr = sp_OACreate 'CDONTS.NewMail', @object OUT
EXEC @hr = sp_OASetProperty @object, 'From',@temp
EXEC @hr = sp_OASetProperty @object, 'Subject', @temp
EXEC @hr = sp_OASetProperty @object, 'To', @temp
EXEC @hr = sp_OASetProperty @object, 'Body', @cmd --这里我的邮件正文可能
会超过8000个字,请问如何做到?
EXEC @hr = sp_OASetProperty @object, 'MailFormat', 0
EXEC @hr = sp_OASetProperty @object, 'BodyFormat', 0
EXEC @hr = sp_OAMethod @object, 'Send', NULL
IF @hr <> 0
BEGIN
--- Report error
EXEC @hr = sp_OAGetErrorInfo @object, @source OUT, @description OUT
IF @hr = 0
BEGIN
select @description
END
END
EXEC @hr = sp_OADestroy @object