原始txt中的内容例如:1234567890测试test
导出后的txt内容变成了:11 31323334353637383930B2E2CAD474657374
使用的SQL语句如下:
create table Test(ID int identity(1,1),blob varbinary(max));
delete from test1.dbo.Test
go
select * from test1.dbo.Test
go
INSERT INTO test1.dbo.Test
SELECT *
FROM OPENROWSET(BULK 'D:\test.txt', SINGLE_BLOB) AS blob
go
EXEC master..xp_cmdshell 'bcp "select * from test1.dbo.Test" queryout "D:/DT2.txt" -c -T'
go