Parameters

• bryan99y

  SSCarpal Tunnel

  Points: 4672

  More actions

  July 12, 2002 at 9:54 pm

  #158429

  Is there a way to pass :\ to a stored procedure?

  This is what I am trying to do:

  SP_DB_BACKUP eCommerce, E:\SQLBackup

  BUT, the :\ is causing me problems.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  July 12, 2002 at 10:55 pm

  #432657

  you need to pass as a char/varchar like this

  SP_DB_BACKUP eCommerce, 'E:\SQLBackup'

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)