Loop Stored Procedure in VB.Net (win form)
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 tr开发者_如何学Pythonied the SP and it works perfectly in SQLServer
Third parameter is bad, should be:
objDL.BackupTables(220, i, 1)
精彩评论