cong sqlserver 导出image 字段的数据

最新推荐文章于 2024-09-14 19:55:29 发布

iteye_12501

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量493

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/iteye_12501/article/details/82360695

版权

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

DECLARE @SOURCEPATH VARBINARY(MAX),
@DESTPATH VARCHAR(MAX),
@ObjectToken INT,
@image_ID VARCHAR(MAX)

DECLARE IMGPATH CURSOR FAST_FORWARD FOR
SELECT job_data,job_name from TBL_TIMER_JOB_DETAILS
OPEN IMGPATH

FETCH NEXT FROM IMGPATH INTO @SOURCEPATH, @image_ID

WHILE @@FETCH_STATUS = 0
BEGIN
SET @DESTPATH = 'c:\' + @image_ID + '.obj'
print(@image_ID)
print(@DESTPATH)

EXEC sp_OACreate 'ADODB.Stream', @ObjectToken OUTPUT
EXEC sp_OASetProperty @ObjectToken, 'Type', 1
EXEC sp_OAMethod @ObjectToken, 'Open'
EXEC sp_OAMethod @ObjectToken, 'Write', NULL, @SOURCEPATH
EXEC sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @DESTPATH, 2
EXEC sp_OAMethod @ObjectToken, 'Close'
EXEC sp_OADestroy @ObjectToken

FETCH NEXT FROM IMGPATH INTO @SOURCEPATH, @image_ID
END

CLOSE IMGPATH
DEALLOCATE IMGPATH