title: Set a SP return value to a variable in SQL Server
body: <p>I have a sproc that returns a single line and column with a text, I need to set this text to a variable, something like:</p>
  
  <pre><code>declare @bla varchar(100)
  select @bla = sp_Name 9999, 99989999, 'A', 'S', null
  </code></pre>
  
  <p>but of course, this code doesn't work...</p>
  
  <p>thanks!</p>