INSERT INTO tblSmartpayFiles
SELECT (select intPKAutoACBFileID from tblACBFiles where strPacsNum = @pacs),@type, @pacs,
BulkColumn FROM OPENROWSET(
Bulk 'd:\FilestreamData\L1DAYESHM6', SINGLE_BLOB) AS BLOB
Hi I have the above script which i used to test with,but now i need to replace the directory after the "Bulk" to a variable named @directory.
how will I go about doing this?
just adding @directory doesnt work.
Bulk @directory, SINGLE_BLOB) AS BLOB
so ultimately i want something like this.