How to print uniqueidentifier or binary data type?

• dlu

  SSC-Addicted

  Points: 472

  More actions

  June 24, 2003 at 3:02 pm

  #82395

  In MSDB, all job_ID are uniqueidentifier data type, sometimes Job_ID is binary datatype. I need to print 'job_ID: ' + cast(@job_ID as varchar(100)). It prints nothing...

  How could I convert and print the contents of Job_ID?

  thanks

  David

• mccork

  SSC-Insane

  Points: 22288

  More actions

  June 24, 2003 at 4:10 pm

  #462898

  The following works for me:

  select 'job_ID: ' + cast(job_ID as varchar(100)) from sysjobs

  Also the following works:

  declare @job_id uniqueidentifier

  select top 1 @job_id = job_id from sysjobs

  print 'job_ID: ' + cast(@job_ID as varchar(100))

  Is it possible your variable @job_id is NULL? ie. you haven't fetched a value into it?

  
  Cheers,
  - Mark