59 lines
2.4 KiB
Transact-SQL
59 lines
2.4 KiB
Transact-SQL
if db_name() in('master','model','msdn','tempdb')
|
|
begin
|
|
DECLARE @ErrorMsg varchar(255)
|
|
SET @ErrorMsg = 'Don''t add these procedures and functions to ' + db_name()
|
|
PRINT '=========================================================================='
|
|
PRINT ''
|
|
PRINT @ErrorMsg
|
|
PRINT ''
|
|
PRINT 'You probably want to be in the VEPROMS Referenced Object (RO) database'
|
|
PRINT ''
|
|
PRINT '=========================================================================='
|
|
RAISERROR (@ErrorMsg, 20, -1) with log
|
|
RETURN
|
|
end
|
|
print 'Adding procedures and functions to ' + db_name()
|
|
|
|
-----------------------------------------------------------------------------
|
|
/*
|
|
---------------------------------------------------------------------------
|
|
| ADD New Code Before this Block |
|
|
| Change Date and Description |
|
|
---------------------------------------------------------------------------
|
|
*/
|
|
-----------------------------------------------------------------------------
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[vesp_GetSQLCodeRevision]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
|
|
DROP PROCEDURE [vesp_GetSQLCodeRevision];
|
|
GO
|
|
|
|
/*****************************************************************************
|
|
Volian Enterprises - Proprietary Information - DO NOT COPY OR DISTRIBUTE
|
|
Copyright 2019 - Volian Enterprises, Inc. All rights reserved.
|
|
*****************************************************************************/
|
|
CREATE PROCEDURE [dbo].[vesp_GetSQLCodeRevision]
|
|
WITH EXECUTE AS OWNER
|
|
AS
|
|
BEGIN TRY -- Try Block
|
|
BEGIN TRANSACTION
|
|
-- Change information in the next line when you are done
|
|
set nocount on
|
|
DECLARE @RevDate varchar(255)
|
|
DECLARE @RevDescription varchar(255)
|
|
set @RevDate = '01/09/2020 11:00 AM'
|
|
set @RevDescription = 'Initial Version'
|
|
Select cast(@RevDate as datetime) RevDate, @RevDescription RevDescription
|
|
PRINT 'SQL Code Revision ' + @RevDate + ' - ' + @RevDescription
|
|
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 'StoredProcedure [vesp_GetSQLCodeRevision] Succeeded'
|
|
ELSE PRINT 'StoredProcedure [vesp_GetSQLCodeRevision] Error on Creation'
|
|
go
|
|
vesp_GetSQLCodeRevision
|