Passing output Parameter to calling sp variable

• Jules Bonnot

  SSCertifiable

  Points: 5488

  More actions

  January 18, 2007 at 7:11 am

  #115693

  could someone tell me how to do this.

  ----Inner sp--------------

  create proc test

  @out int output

  as

  select @out = 1

  select @out

  ----------------

   

  i want to assign the output param to a local variable  something like

  declare @i int

  set @i = exec test @out = 2

   

  Cheers for any help.

  Jules

   

  www.sql-library.com[/url]

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 18, 2007 at 7:42 am

  #683999

  Jules

  Is this what you're after?

  declare

  @i int

  exec test @out = @i output

  select @i

  John