Professional Web Applications Themes

how can I roll back an insert?? - Microsoft SQL / MS SQL Server

There are 6 tables getting a 'bulk insert' each when my program does one order...if one bulk insert is successful and one of the next ones is not, what is the 'roll back' command to undo this: sqlstr = "BULK INSERT [Mink].[dbo].[TBL_Client_stage0]" + _ " FROM '\nas01\orderdata\Program1.txt' WITH (CHECK_CONSTRAINTS, FIELDTERMINATOR = '\t', KEEPNULLS, MAXERRORS =100)" sqlInsertCommand2.CommandText = sqlstr sqlInsertCommand2.ExecuteNonQuery() thanks, Trint .Net programmer com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

Sponsored Links
  1. #1

    Default how can I roll back an insert??

    There are 6 tables getting a 'bulk insert' each when my program does one
    order...if one bulk insert is successful and one of the next ones is
    not, what is the 'roll back' command to undo this:

    sqlstr = "BULK INSERT [Mink].[dbo].[TBL_Client_stage0]" + _
    " FROM '\\nas01\orderdata\Program1.txt' WITH
    (CHECK_CONSTRAINTS, FIELDTERMINATOR = '\t', KEEPNULLS, MAXERRORS =100)"
    sqlInsertCommand2.CommandText = sqlstr
    sqlInsertCommand2.ExecuteNonQuery()

    thanks,
    Trint



    .Net programmer
    com

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Sponsored Links
    Trint Guest

  2. #2

    Default Re: how can I roll back an insert??

    A single BULK INSERT statement can be rolled back by defining our own
    transactions and using the BATCHSIZE parameter so that the input file is
    broken into multiple batches. I'm not sure if multiple BULK INSERT
    statements can be treated as a single transaction.

    DTS can handle this situation better, provided you can code your logic using
    DTS.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Trint Smith" <com> wrote in message
    news:%phx.gbl... 


    SriSamp Guest

  3. #3

    Default Re: how can I roll back an insert??

    uhh, i was hoping for a stored procedure..
    thanks,
    Trint

    Net programmer
    com

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Trint Guest

  4. #4

    Default Re: how can I roll back an insert??

    What?

    --
    Hz


    Trint Smith typed:

    | uhh, i was hoping for a stored procedure..
    | thanks,
    | Trint


    Hz Guest

Similar Threads

  1. flash player roll back
    By krakooshn in forum Macromedia Flash Player
    Replies: 0
    Last Post: September 22nd, 09:24 PM
  2. How to roll back the system automatically
    By stephen in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 14th, 10:40 PM
  3. system clock roll back
    By martin in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 7th, 07:04 PM
  4. Replies: 2
    Last Post: June 25th, 12:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139