when to use ForEach/For Loop/Sequence Container?
Question
Answers
-
For Each loop :
When you are not sure how many times the loop needs to run especially when you want to do a set of process for each file in a folder, or number of records in an object variable.
For Loop: When you know that a task need to run for a fixed amount of time like 10 iterations.
Seq Container: It is used to club together different tasks into logical gorups for better understanding and setting transactions to a set of tasks.
Tweet me..
- Proposed as answer by Reza RaadMVP Monday, November 8, 2010 9:22 PM
- Marked as answer by SqlRockss Tuesday, November 9, 2010 2:30 PM
All replies
-
For Each loop :
When you are not sure how many times the loop needs to run especially when you want to do a set of process for each file in a folder, or number of records in an object variable.
For Loop: When you know that a task need to run for a fixed amount of time like 10 iterations.
Seq Container: It is used to club together different tasks into logical gorups for better understanding and setting transactions to a set of tasks.
Tweet me..
- Proposed as answer by Reza RaadMVP Monday, November 8, 2010 9:22 PM
- Marked as answer by SqlRockss Tuesday, November 9, 2010 2:30 PM
