using ' within a Unicode sting

• AHWB

  Ten Centuries

  Points: 1096

  More actions

  March 14, 2012 at 9:44 am

  #254757

  Sure this is a simple, and probably stupid question but I need help with the following;

  I run the following to show all jobs

  use msdb

  go

  sp_help_job

  This returns all jobs. one of the jobs includes single quotes. For example;

  Daily 'full' backup

  I then want to run;

  use msdb

  go

  sp_help_job

  @job_name = N'Daily 'full' backup',

  @job_aspect = N'all'

  However it failes due to the single quotes. If for example the job was called;

  Daily full backup

  The SQL executes correctly. I have managed to work around this by using @job_id instead of @job name but would like to understand why this didn't work, is there a reason or way to using single quotes.

• Andy Hyslop

  SSCrazy Eights

  Points: 9198

  More actions

  March 14, 2012 at 9:48 am

  #1459307

  As far as I know no not using single quotes - you need to use double quotes.

  use msdb

  go

  sp_help_job

  @job_name = N'Daily ''full'' backup',

  @job_aspect = N'all'

  ==========================================================================================================================
  A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

• AHWB

  Ten Centuries

  Points: 1096

  More actions

  March 14, 2012 at 9:54 am

  #1459316

  Thanks, I thought I tried that, but obviously had a typing error somewhere. Just tried again and that worked. Told you it was a stupid question.

  Thanks for the prompt reply.

• Andy Hyslop

  SSCrazy Eights

  Points: 9198

  More actions

  March 14, 2012 at 9:56 am

  #1459320

  Not a stupid question at all!

  Your welcome

  Andy

  ==========================================================================================================================
  A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe