Skip to content

Instantly share code, notes, and snippets.

@MirzaMerdovic
Created October 9, 2017 20:15
Show Gist options
  • Save MirzaMerdovic/c707ee133ea27af8d0852e08c4b4dbef to your computer and use it in GitHub Desktop.
Save MirzaMerdovic/c707ee133ea27af8d0852e08c4b4dbef to your computer and use it in GitHub Desktop.
SQL Tips and Tricks
WITH ROLLBACK IMMEDIATE
The ROLLBACK IMMEDIATE command tells the SQL Server that if it can’t complete the command right away,
then the other pending transactions should be rolled back.
Note: Option will disconnect all other users from the database.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment