Announcing the New PowerShell Virtual Chapter of PASS!

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mshawky1980 SSC Rookie Points: 28 More actions · Answer 1

You Can do that from vb.net by combain many sql statment in loop and send it at once to executed in server like that

dim strsql as string =""

dim i as integer

for i = 0 to 10

strsql = "insert Into table1 values("","","") ;"

contenue

dim cmd as new sqlcommane (strsql, con as connsectiom )

cmd.executeNoneQuary

Robert.Sterbal SSCrazy Points: 2855 More actions · Answer 2

Are you posting the recordings of the events anywhere?

Thanks!

Cookies on SQLServerCentral