I desperately need some help in writing the string below in a stored procedure. I cant seem to get the quotations correct.
\\10.49.32.235\webshared\spares\ is a string and needs to be enclosed in single quotations
@MyFile is a variable that I am passing to the procedure
FIELDTERMINATOR =',' The , has to be enclosed in single quotes for this line to.
Any help you could give me would be greatly appreciated.
Select @Sql ='
BULK INSERT spares
FROM '\\10.49.32.235\webshared\spares\' + @MyFile +
'WITH (FIELDTERMINATOR =',')'