How i can run this mysql query in SQL Server? : <p>Basically I need to run this query in SQL Server. I executed in MySQL and it works fine.</p>

<pre><code>SET @startID:=29;
update test
set ID=@startID:=@startID+1;
</code></pre>

<p>Thanks</p>
