Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
securing critical sections with manual locks in sql server
CREATE PROCEDURE [dbo].[Some_proc] AS BEGIN SET NOCOUNT ON; BEGIN TRAN BEGIN TRY exec sp_getapplock @Resource = 'resource_name', @LockMode = 'exclusive',@LockTimeout = '60000', @DbPrincipal = 'dbo' --will be released when transaction commits or rolled back --code that follows will be executed only by one process at a time select * from Pilots COMMIT END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK; declare @err nvarchar(max) = ERROR_MESSAGE() RAISERROR (@err, 16, 1) END CATCH END go exec Some_proc
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
"OrderForm.asp?Cart="
elie homsi's code
OFFSET FETCH Clause
ms sql - update/insert - date concatenation
Checking SQL Job run status
New
Veterinary 1
Stuff
Exa
Pivot unpivot
Please log in to post a comment.