Passing Symbols as Input to SP

• Genie Cool

  SSC-Addicted

  Points: 478

  More actions

  January 16, 2008 at 4:08 am

  #62941

  Hi,

  I have the following SP.

  create proc Sample

  (

  @sample varchar(10)

  )

  as

  Begin

  print @sample

  End

  When I execute

  exec sample 'sampletest^'

  It just shows 'sampletest' and the '^' symbol is missing. This happens with all the symbols. But if I pass the symbol alone it works fine.

  Can somebody help with this?

  ---

  Regards,
  Genie Cool
  

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  January 16, 2008 at 4:13 am

  #768554

  String 'sampletest^' has 11 symbols.

  And you parameter is VARCHAR(10).

  11^th symbol is just truncated.

  _____________
  Code for TallyGenerator