QUOTED_IDENTIFIER Setting for SQL Server Client

• qiwenxian

  Grasshopper

  Points: 20

  More actions

  January 4, 2011 at 11:58 am

  #245011

  When I ran SQL Query with double quotes in one machine, no problem, but ran the same query in another one got error:

  if @TimeStampFilterOption = 'Today Only'

  select @FilterDate = convert(char(11),getdate(),120) + " 00:01"

  Msg 207, Level 16, State 1, Line 39

  Invalid column name ' 00:01'.

• VRR

  Ten Centuries

  Points: 1170

  More actions

  January 4, 2011 at 12:23 pm

  #1269162

  Ther server where it ran with out any problem is due to quoted_identifier is set off.

  Run SET QUOTED_IDENTIFIER OFF before running your query.

• qiwenxian

  Grasshopper

  Points: 20

  More actions

  January 4, 2011 at 5:51 pm

  #1269270

  I have lots of scripts to run everyday, it's not woking to change all of the scripts to set to OFF individually.