30 lines
822 B
Transact-SQL
30 lines
822 B
Transact-SQL
|
|
/****** Object: StoredProcedure [deleteSession] ******/
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[deleteSession]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
|
|
DROP PROCEDURE [deleteSession];
|
|
GO
|
|
|
|
CREATE PROCEDURE [dbo].[deleteSession]
|
|
|
|
(
|
|
@SessionID int
|
|
)
|
|
WITH EXECUTE AS OWNER
|
|
AS
|
|
BEGIN TRY -- Try Block
|
|
BEGIN TRANSACTION
|
|
DELETE [Sessions]
|
|
WHERE [SessionID] = @SessionID
|
|
IF( @@TRANCOUNT > 0 ) COMMIT
|
|
END TRY
|
|
BEGIN CATCH -- Catch Block
|
|
IF( @@TRANCOUNT = 1 ) ROLLBACK -- Only rollback if top level
|
|
ELSE IF( @@TRANCOUNT > 1 ) COMMIT -- Otherwise commit. Top level will rollback
|
|
EXEC vlnErrorHandler
|
|
END CATCH
|
|
GO
|
|
-- Display the status of Proc creation
|
|
IF (@@Error = 0) PRINT 'Procedure Creation: deleteSession Succeeded'
|
|
ELSE PRINT 'Procedure Creation: deleteSession Error on Creation'
|
|
GO
|