title: Creating procedure SQL Server 2008 R2
body: <p>I'm new to SQL, and I'm trying to learn it. I'm creating a procedure to INSERT Members into Member table.</p>
  
  <p>Im using this (which ofc works):</p>
  
  <pre><code>CREATE PROCEDURE InsertMember
  AS
  INSERT INTO Member (FirstName, LastName, City)
  VALUES ('Blla', 'Blla', 'Blla')
  </code></pre>
  
  <p>But... I want to know if it is possible to create a procedure which when I execute it, to ask user for input. For example: When I execute the procedure it should go like this:</p>
  
  <pre><code>@FirstName = 'SOME FIRSTNAME'
  @LastName = 'SOME LASTNAME'
  @City = 'SOME CITY'
  </code></pre>
  
  <p>I didn't try anything yet, because I don't know if that is possible. Help please ? Any reference ?</p>