selecting mulitiple variable values in a stored procedure

• solus

  Hall of Fame

  Points: 3495

  More actions

  February 15, 2011 at 4:53 am

  #232257

  I have a stored procedure with 2 output parameters

  @value1

  @value2

  I have a select statement and I want to assign the results to the 2 variables, something like this

  SELECT @value1,@value2 = column1, column2 from table where table.id = @id

  this syntax is incorrect though, how can I achieve this ? Is this even the correct way ?

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  February 15, 2011 at 5:05 am

  #1286971

  SELECT @value1=column1 ,@value2=column2 from table where table.id = @id

  Don't forget to define the parameters as output in both the stored procedure and the calling script.

• solus

  Hall of Fame

  Points: 3495

  More actions

  February 15, 2011 at 5:51 am

  #1286989

  thanks, that sorted it