find d:\binary -name *.dat -type f > out.txt
CREATE TABLE files(filepath varchar(512),file_id INT IDENTITY(1,1))
BULK INSERT filesFROM 'd:\out.txt'WITH (fieldterminator='',rowterminator='\n';
CREATE TABLE bindata(data varbinary(max),file_id INT IDENTITY(1,1))
DECLARE @filename VARCHAR(512),@sql VARCHAR(512);DECLARE a_cur CURSOR STATIC FORSELECT filepath FROM files;/*WHERE file_id >(SELECT MAX(file_id) FROM bindata); This part is needed when you load the data NOT for the first time from the files table. */
EXEC sp_configure 'xp_cmdshell', 1GORECONFIGUREGO
DECLARE @a INTDECLARE @i INT,@filename VARCHAR(300),@cmd VARCHAR(500)SET @i = 0;