Sql大文件 txt加载

UPDATE dbo.CustomerData
SET txt_data = (SELECT txt_data FROM OPENROWSET(
BULK 'c:\temp\textfile101.txt', SINGLE_CLOB) AS F(txt_data)),
ntxt_data = (SELECT ntxt_data FROM OPENROWSET(
BULK 'c:\temp\unicodefile101.txt', SINGLE_NCLOB) AS F(ntxt_data)),
binary_data = (SELECT binary_data FROM OPENROWSET(
BULK 'c:\temp\binaryfile101.jpg', SINGLE_BLOB) AS F(binary_data))
WHERE custid = 101;

posted @ 2016-01-19 11:07  applekingghfhfhbr  阅读(155)  评论(0编辑  收藏  举报