Passing a variable to the Kill command

• rodrigub

  Say Hey Kid

  Points: 682

  More actions

  July 25, 2003 at 12:11 pm

  #82922

  I am trying to pass a variable to the kill command instead of the actual spid. I keep getting a syntax error. I declare the variable, set the variable then pass the variable. Am I doing something wrong?

• mdaniel

  SSCarpal Tunnel

  Points: 4616

  More actions

  July 25, 2003 at 1:26 pm

  #467138

  Try using the exec command.

  
  
  declare @pid as int
  
  set @pid = 50
  
  exec ('kill ' + @pid)
  
   

• rodrigub

  Say Hey Kid

  Points: 682

  More actions

  July 25, 2003 at 1:52 pm

  #467142

  That works. Thank you!