22,301
社区成员




create table test(id int identity, bin varbinary(max))
go
insert test default values
insert test default values
insert test default values
insert test default values
go
select * from test
/*
id bin
----------- ---------------------
1 NULL
2 NULL
3 NULL
4 NULL
*/
-- 系统程序.rar = 397,541,151Byte = 379M
insert test select * from openrowset(bulk 'X:\...\系统程序.rar', single_blob) as bin
select * from test where id<5
/*
id bin
----------- ---------------------
1 NULL
2 NULL
3 NULL
4 NULL
5 0x526172211A0700CF...
*/