Chris Tracy yzorg
yzorg
/ trycatchtran.sql
Last active
June 19, 2020 12:58
— forked from mishrsud/trycatchtran.sql
SQL TRY-CATCH WITH TRANSACTION
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE PROCEDURE [dbo].[spTxnDemo] | |
| @debug int = NULL | |
| , @forceError int = NULL | |
| AS | |
| BEGIN | |
| SET NOCOUNT ON; | |
| SET @debug = ISNULL(@debug, 0); | |
| SET @forceError = ISNULL(@forceError, 0); | |
| BEGIN TRY | |
| BEGIN TRANSACTION MY_TXN; |
yzorg
/ IE 'Send to Chrome' bookmarklet
Last active
December 11, 2015 03:08
— forked from anonymous/gist:4334192
'Send to Chrome' button in IE, adds chrome2:// protocol to Windows
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // in desktop IE and metro IE - create a bookmark with the line below | |
| javascript:document.location=("chrome2://"+document.location) |