title: create a store procedure and create a job on sql server
body: <p>the definition of a procedure in oracle database very simple. but in SQL Server wife to come to me too. Can you help in this regard. According to the oracle sql server really think excessive unnecessary. Am I wrong, but I do not know this kind of ORACLE process very simple and straightforward. I think oracle systematically.</p>
  
  <pre><code>   for a in  (select * from mytablen but where x = 1) 
          loop  
                   insert into myothertable (a, b, c, d) values (a.AA, a.BB, a.CC,a.DD) 
      end loop;
  </code></pre>
  
  <p>How can I encode it in sql server.
  sql server agent management studio express don't work. 
  <a href="https://stackoverflow.com/questions/26870622/sql-server-management-studio-2014-new-trigger-disable-button">In SQL Server Management Studio 2014, the New Trigger menu option is disabled</a>
  trigger button is disabled...
  job create dont work.... </p>
  
  <p>:((</p>
  
  <pre><code>I'm really sorry but
      I'm like a donkey riding up and down from the horse
  </code></pre>