calling stored procedure inside while loop
Hi,
I noticed that in Sql server 2000 it is not possible to call a stored procedure
inside the while loop. I have a while loop similar to the following inside a stored procedure which in turn calls a stored procedure. However an error is thrown.
while (intNumber < 10)
Begin
Exec someStoredProcedure
intNumber = intNumber + 1
End
thanks in advance :)
Re: calling stored procedure inside while loop
Quote:
I noticed that in Sql server 2000 it is not possible to call a stored procedure inside the while loop.
It certainly is possible.
Quote:
However an error is thrown.
Post the error information.
Re: calling stored procedure inside while loop
That is not real T-SQL code - it would be more like this:
Code:
declare @intnumber int
set @intnumber=0
while (@intNumber < 10)
Begin
Exec someStoredProcedure
set @intNumber = @intNumber + 1
End
If what you posted was not real code - please post the real code.