title: Using Variables Passing Into MSSQL Stored Proc as part of queries
body: <p>I want to use the value from variables that is passed into the stored proc. Is that allow?</p>
  <p>For example, I want to pass CID=5,SID=4 Into an Update Stored Proc</p>
  <p>and it looks like this:</p>
  <pre><code>CREATE PROCEDURE Update @CID nvarchar(4),@SID nvarchar(4)
  AS
  
  DELETE FROM [User&quot;+@CID+@SID+&quot;] 
  
  GO;
  </code></pre>
  <p>In which is like &quot;DELETE FROM [User54]&quot;</p>
  <p>But I want to dynamically done given the parameter</p>
  <p>Can it be done and how is it done?</p>
  <p>Thanks</p>