Loop Stored Procedure in VB.Net (win form)
Posted
by Mo
on Stack Overflow
See other posts from Stack Overflow
or by Mo
Published on 2010-04-28T14:09:04Z
Indexed on
2010/04/28
14:13 UTC
Read the original article
Hit count: 258
Hello,
I am trying to run a for loop for a backup system and inside that i want to run a SP that will loop. Below is the code that does not work for me..
Any ideas please?
Dim TotalTables As Integer
Dim i As Integer
TotalTables = 10
For i = 1 To TotalTables
objDL.BackupTables(220, i, 001) ' (This is a method from the DL and the 3 parameters are integars)
Next
I tried the SP and it works perfectly in SQLServer
© Stack Overflow or respective owner