declare @file_path nvarchar(50);
-- declare the size as needed (no limit)
declare @sql nvarchar(500);
select
@file_path = 'C:\\Useless\\Temp\\some_file.txt',
@sql = 'insert into #FileContents
select f.BulkColumn
from openrowset
(
bulk ''' + @file_path + ''',
single_clob
) f;';
exec (@sql);
No one has followed this question yet.