insert into MyTable (Id, Name, Content)
select '1', 'MyName', cast(BulkColumn as varchar(max)) from OpenRowSet(Bulk N'D:\aaa\bbb.txt', Single_BLOB) as Content
OpenRowSet 范例
最新推荐文章于 2023-10-19 11:22:00 发布
insert into MyTable (Id, Name, Content)
select '1', 'MyName', cast(BulkColumn as varchar(max)) from OpenRowSet(Bulk N'D:\aaa\bbb.txt', Single_BLOB) as Content