Incorrect syntax in sp_send_dbmail

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  October 16, 2009 at 1:07 pm

  #136470

  EXEC msdb.dbo.sp_send_dbmail

  @recipients = 'EMAIL REMOVED',

  @subject = 'Something Important',

  @query = 'select * from TableName where Source = 1 and (name like '%I%' or '%O%')',

  @attach_query_result_as_file = 1,

  @profile_name = 'sqldba',

  @body_format = 'HTML'

  I m getting, Incorrect syntax near '%' . Can some one help me out in this??

  Thanks a lot..

• Allister Reid

  SSCrazy

  Points: 2666

  More actions

  October 16, 2009 at 1:16 pm

  #1067145

  do you mean?

  EXEC msdb.dbo.sp_send_dbmail

  @recipients = 'EMAIL REMOVED',

  @subject = 'Something Important',

  @query = 'select * from TableName where Source = 1 and (name like '%I%' or name like '%O%')',

  @attach_query_result_as_file = 1,

  @profile_name = 'sqldba',

  @body_format = 'HTML'

• matt6288

  SSCertifiable

  Points: 5058

  More actions

  October 16, 2009 at 1:20 pm

  #1067148

  ssismaddy (10/16/2009)

  ---

  EXEC msdb.dbo.sp_send_dbmail

  @recipients = 'EMAIL REMOVED',

  @subject = 'Something Important',

  @query = 'select * from TableName where Source = 1 and (name like '%I%' or '%O%')',

  @attach_query_result_as_file = 1,

  @profile_name = 'sqldba',

  @body_format = 'HTML'

  I m getting, Incorrect syntax near '%' . Can some one help me out in this??

  Thanks a lot..

  I think you need to double up the single quotes. I can't test this so if it doesn't work let me know.

  EXEC msdb.dbo.sp_send_dbmail

  @recipients = 'EMAIL REMOVED',

  @subject = 'Something Important',

  @query = 'select * from TableName where Source = 1 and (name like ''%I%'' or ''%O%'')',

  @attach_query_result_as_file = 1,

  @profile_name = 'sqldba',

  @body_format = 'HTML'

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  October 16, 2009 at 1:45 pm

  #1067162

  Thanks eveyone for your replies...It worked with the 2 single quotes

  Thank you Matt...