Code Snippets

While Loop in stored procedure

By Shefeek Jinnah - For Technical Information ⋅ April 22, 2009 ⋅ Post a comment


CREATE PROCEDURE sp1 (start_val integer, end_val integer, …)
AS
declare variable i integer;
BEGIN
i = start_val;
while (i < end_val)
begin
…
i = i + 1;
end
END

Share

Thanks for reading my blog. If you like what I write, why not subscribe to my feed?

If you are busy, I can send the latest post to your email. Just subscribe to my email updates.

 

Enter your email address:

Delivered by FeedBurner

Tags :  ,

Discussion

No comments for “While Loop in stored procedure”

Post a comment