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;