Evan,

It's really easy. Type COMMIT (or ROLLBACK) into the same query window (same connection) as the rest of your interactive stuff, highlight it, and execute it (F5).

>I want to do the changes interactively, not with code.
>
>>

>>BEGIN TRANSACTION T1
>>
>>   Update and Verify Data here
>>
>>if (Data Verified)
>>   COMMIT TRANSACTION T1
>>else
>>   ROLLBACK TRANSACTION T1
>>
>>

>>
>>You may also Nested Transaction like this
>>

>>BEGIN TRANSACTION T1
>>
>>  BEGIN TRANSACTION T2
>>
>>   Update and Verify Data here
>>  if (Data Verified)
>>     COMMIT TRANSACTION T2
>>  else
>>     ROLLBACK TRANSACTION T2
>>
>>
>>
>>if (Data Verified)
>>   COMMIT TRANSACTION T1
>>else
>>   ROLLBACK TRANSACTION T1
>>
>>