title: tsql for loop on a list
body: <p>How can I write this code in T-SQL?</p>
  
  <pre><code>var categories = new []{ "cat1", "another category", "one more" };
  for (var i = 0; i&lt;categories.count; i++)
  {
      insert into Categories (id, name)
      values (i, categories[i])
  }
  </code></pre>
  
  <p>Is it possible?</p>