Viewing 3 posts - 1 through 3 (of 3 total)
Using transactions looks like the best way to prevent such mistakes.
An alternative would be to use 'set rowcount'. The rowcount value can be 1 more than the number of rows...
June 16, 2005 at 10:14 am
#566195
Actually either F5 or "Ctrl+E" or "ALT+X" will execute code.
I prefer "ALT+X" as the keys are close to my fingers.
May 10, 2005 at 8:39 am
#557801
For context sensitive help from BOL, you can highlight the SQL keyword(s) and type "SHIFT+F1"
May 9, 2005 at 12:44 pm
#557689