Tuesday 4 May 2021
To check if the procedure already exists and drop
IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'ProcedureName')
DROP PROCEDURE ProcedureName
GO
Subscribe to:
Posts (Atom)
IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'ProcedureName')
DROP PROCEDURE ProcedureName
GO