In this article we learn how we can run a cursor in sql server to validate all users.
declare @field1 varchar(100)
declare @field2 varchar(100)
declare cur CURSOR LOCAL for
select field1, field2 from sometable where someotherfield is null
open cur
fetch next from cur into @field1, @field2
while @@FETCH_STATUS = 0 BEGIN
--execute your sproc on each row
exec yourloginprocedure @field1, @field2
fetch next from cur into @field1, @field2
END
close cur
deallocate cur
0 Comments