Can someone please tell me what I did wrong here. I'd replaced the double quote with a single quote but it complained about Unclosed quotation mark before the character string '\n)'.
HERE'S THE DOUBLE QUOTE VERSION:
SET @Query_tmp = "BULK INSERT dbo.dbAnntest FROM '"+@TmpLocation+"' WITH (FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n')"
AND HERE'S THE SINGLE QUOTE VERSION:
SET @Query_tmp = 'BULK INSERT dbo.dbAnntest FROM '+@TmpLocation+' WITH (FIELDTERMINATOR = ''\t'', ROWTERMINATOR = ''\n)'
Thanks