Computing.Net > Forums > Database > use of commit and rollback

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

use of commit and rollback

Reply to Message Icon

Name: trichyselva
Date: April 18, 2006 at 23:08:48 Pacific
OS: windows xp
CPU/Ram: p4
Product: pentium
Comment:

suppose i execute 10 sql's, i want to commit 6 sql's and rollback 4 sql's, is there any way to do it ( i haven't mentioned savepoint anywhere between the sql's), any other way other than savepoint



Sponsored Link
Ads by Google

Response Number 1
Name: lchi2000g
Date: April 19, 2006 at 17:51:00 Pacific
Reply:

YES.

rollback and run the 6 sql's again and commit it.

I was just joking. The real answer is NO.


Luke Chi


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: use of commit and rollback

Script to check database status www.computing.net/answers/dbase/script-to-check-database-status-/393.html

Remote copies of Act 6 running slo www.computing.net/answers/dbase/remote-copies-of-act-6-running-slo/175.html

mysqld-nt.exe consumes most of CPU www.computing.net/answers/dbase/mysqldntexe-consumes-most-of-cpu/356.html