SQL Syntax in Profiler vs. Query Analyzer

• jsqldba

  SSChampion

  Points: 11257

  More actions

  July 20, 2001 at 4:15 am

  #157564

  The queries returned by Profiler in a trace, use quotation marks around the table and collumn names i.e.

  SELECT DISTINCT "Global Sales"."CONSOLIDATION", "Global Sales"."CURRENCY" FROM "Global Sales"

  To use this query in Query Analyzer, I must first edit the quotes to brackets [] i.e.

  SELECT DISTINCT [Global Sales].[CONSOLIDATION], [Global Sales].[CURRENCY] FROM [Global Sales]

  This is a PITA ;)...

  Is there an option someplace to have Query Analzyer recognize the quotes? Or for Profiler to report with brackets? Or another solution perhaps?

  Thanks

  Jay

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  July 20, 2001 at 4:43 am

  #417208

  SET QUOTED_IDENTIFIER ON

  GO

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• jsqldba

  SSChampion

  Points: 11257

  More actions

  July 20, 2001 at 4:46 am

  #417209

  Great thanks, and I didn't have to wait for someone in the USA to wake up!

  Jay