If you ever google sql for loop, just stop right there.
SQL is by definition a for loop.
A SELECT statement does nothing more than iterate over the rows in the database that satisfy the conditions of the query.
Therefore, if you want a for loop that sets a variable and then does some operation on one row at a time, JUST STOP. What you really want is a join somehow, and you can get it all done much simpler in terms of code and processing power. It will be easier to debug and to understand, and you won't have to worry about setting up the attendant variables to process a true for loop. SQL is a for loop, use it that way!
Popular Posts
-
If you ever google sql for loop, just stop right there. SQL is by definition a for loop. A SELECT statement does nothing more than itera...
-
Background Every Microsoft SQL Server database, there is a folder called Server Objects. Within that folder there is a folder called "... -
The object of copying code is to save time. However, I have discovered by sad and repeated experience that copying code more often than not...
-
Last night I thought about how stable God is. He plants his promises in our hearts and watches them grow. As men, we foolishly think that ...
-
Rules of Coding The most important language you will ever code in: English (or the common spoken language used in your company). -- So...
