Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhun_garma
Starting Member
15 Posts |
 Posted - 2002-02-12 : 00:24:30
|
| I'm try to update 30 records over the internet. my problem is that my internet connection is not stable. I tend to be disconnected.what do you thinks is the best way to update this records using stored procedure while using an all or nothing method,this means that if i diconnected while updating the rollback transactions will be activated. I'm try to send the records as comma delimited string, then parse it in the stored procedure then update it in the database is this the best way, your opinion is will be highly appreciatedthanks in advance |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-12 : 00:50:38
|
If you do it in a stored procedure, once it starts to run, if you drop off the net, it will still run.Also, if you are trying to develop a serious application, it might be time to get a decent internet connection. Maybe unplug the other phones on the line  Damian |
 |
|
|
jhun_garma
Starting Member
15 Posts |
Posted - 2002-02-12 : 01:44:36
|
| thanksat least if i run it in a stored procedure I'm sure that it will finish executing, is this correct?. besides having a decent internet connection do you have any suggestions on how to proceed? |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-12 : 03:15:36
|
Until it doesnt encounters a error in the Stored procedure itself or someother server problem occur. if it does you will not be in a position to know whether the stored procedure was succefully executed or not.quote:
at least if i run it in a stored procedure I'm sure that it will finish executing, is this correct?.
--------------------------------------------------------------"Happiness is not something you experience, it's something you remember." |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-12 : 07:32:25
|
Yes you are correct, once the parameters have been passed to the stored proc and it has been called, it will run. Provided you don't have any errors (as Nazim says).To the second part of your question...If I was building you a house, and I asked "apart from making sure the concrete was dry before putting the walls up, what should I do to make a good house ?"Would you give me an answer ? NO Damian |
|
|
|
|
|
|
|
|
updating records over the internet