Database

Mike Dimmick wrote:

You should split your script at GO statements.

<br />
declare EmpCur cursor for (select * from Emp where ...}<br />
go<br />
... processing ...<br />
fetch EmpCur into @empId ...<br />
while (@@sqlstatus=0)<br />
   begin<br />
   fetch EmpCur into @empId ...<br />
   ... some processing ...<br />
   insert into #tmp (empId, salary) (@empId, @salary)<br />
   end<br />
<br />
select * from #tmp<br />
go

<br />
DECLARE @ident INT<br />
<br />
SET @ident = SCOPE_IDENTITY()<br />
<br />
IF @ident >= {max value here} BEGIN<br />
    DBCC CHECKIDENT({table name here}, reseed, {new seed value here})<br />
END<br />
<br />