IF EXISTS ( SELECT  * FROM    dbo.sysobjects WHERE   id = OBJECT_ID(N'[dbo].[ExecuteCommand]')  AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[ExecuteCommand]

IF EXISTS ( SELECT  * FROM    dbo.sysobjects WHERE   id = OBJECT_ID(N'[dbo].[TransferOfinformationBetweenFinancialYears]')  AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[TransferOfinformationBetweenFinancialYears]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ChangeGoodsCode]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ChangeGoodsCode]