Replacing double quote with single quote

• mdp

  Ten Centuries

  Points: 1252

  More actions

  May 12, 2004 at 3:10 pm

  #66801

  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

• gdefi

  SSC-Addicted

  Points: 493

  More actions

  May 14, 2004 at 2:32 am

  #506437

  Must close the newline terminator ...

  SET @Query_tmp =

  'BULK INSERT dbo.dbAnntest FROM '+@TmpLocation+' WITH (FIELDTERMINATOR = ''\t'', ROWTERMINATOR = ''\n'')'