how to execute a SP which has a input parameter of type varchar(max)?

• anjali.vishwakarma

  Ten Centuries

  Points: 1112

  More actions

  December 15, 2009 at 1:24 am

  #139989

  I want to execute a SP which has a parameter of type varchar(max). When I right click SP and say execute, it asks for parameters. I have a string of lenght 4000 characters which i want to pass in that parameter.But when I copy and paste that string in that parameter, it gets truncated to very few characters.

  Is there any other way of executing and testing such procedures which have varchar(max) type as input parameter?

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  December 15, 2009 at 2:47 am

  #1092399

  For example

  DECLARE @p VARCHAR(max)

  SET @p = .....

  EXEC your_stored_proc @p