Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Database > Microsoft SQL Server
Reload this Page

Very IMP - PARTIAL ROLLBACK

Discuss Very IMP - PARTIAL ROLLBACK in the Microsoft SQL Server forum on ASP Free.
Very IMP - PARTIAL ROLLBACK Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old September 22nd, 2004, 03:04 AM
sanjay1909 sanjay1909 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Sep 2004
Posts: 21 sanjay1909 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 33 m 29 sec
Reputation Power: 0
Very IMP - PARTIAL ROLLBACK
Is partial Rollback possible
Look the below Logic

FOR 1 TO 100 RECORDS
BEGIN TRANSACTION

INSERT RECORD IN TABLE "A" - assume that we have inserted 10 records without errors in the loop
If Error occurs on the 11th record then I call procedure ERRORLOG
In the ErrorLog procedure I am inserting error description record in Error table

ROLLBACK TRANSACTION - Records should not be inserted in table "A" but inserted in ErrorLog table as there is an error
END
END FOR

Please tell me how is this possible. Is there a seperate block which can commit the transaction only for that block. It is possible in Oracle but I dont know for SQL Server
Reply With Quote
  #2  
Old September 23rd, 2004, 02:23 AM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 22 h 33 m
Reputation Power: 181
Try looking in the SQL Server Books Online. And try posting in an appropriate forum, I see nothing about ASP here.
__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
Reply With Quote
  #3  
Old September 28th, 2004, 09:43 AM
Paula Paula is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jul 2004
Posts: 65 Paula User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 37 m 32 sec
Reputation Power: 5
I don't understand
Is this the SQLServer forum or not? It looks like it to me. I realise this website is called aspfree but there is a SQLServer forum. Are you telling people not to post in it, cos there's about 47 pages of posts in here that don't relate to asp?????? Very confused!
Reply With Quote
  #4  
Old September 28th, 2004, 09:51 AM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
  
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,770 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 7 h 8 m 6 sec
Reputation Power: 469
Quote:
Originally Posted by Paula
Is this the SQLServer forum or not? It looks like it to me. I realise this website is called aspfree but there is a SQLServer forum. Are you telling people not to post in it, cos there's about 47 pages of posts in here that don't relate to asp?????? Very confused!

This question was originally posted in the ASP Development area.
It was moved to the correct forum area by a moderator.
Reply With Quote
  #5  
Old September 30th, 2004, 04:02 AM
Paula Paula is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jul 2004
Posts: 65 Paula User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 37 m 32 sec
Reputation Power: 5
Aha, I see! Now it makes sense.
Reply With Quote
Reply

Viewing: ASP Free Forums > Database > Microsoft SQL Server > Very IMP - PARTIAL ROLLBACK

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway. 
Stay green...Green IT