CREATE PROC My_Proc_GO 
--creates procedure “My_Proc_GO”
	AS 
	BEGIN 
		EXEC ('ALTER PROC My_Proc_GO AS SELECT NULL')
		--alter procedure “My_Proc_GO” to run select statement
		EXEC My_Proc_GO
		-- run the procedure “My_Proc_GO “ this displayes results to screen after it has been modified
		DROP PROC My_Proc_GO
		-- Drop the procedure 
	END 
GO 
--end of batch
EXEC My_Proc_GO
--Does what is says on the tin  executes the stored proc

--EXEC My_Proc_GO

CREATE PROC [dbo].[My_Proc_GO] 
--creates procedure “My_Proc_GO”
	AS 
	BEGIN 
		EXEC ('ALTER PROC My_Proc_GO AS SELECT NULL')
		--alter procedure “My_Proc_GO” to run select statement
		EXEC My_Proc_GO
		-- run the procedure “My_Proc_GO “ this displays results to screen
		DROP PROC My_Proc_GO
		-- Drop the procedure 
	END 

GO

--DROP PROC My_Proc_GO

ALTER PROC [dbo].[My_Proc_GO] AS SELECT NULL

select null 

DROP PROC My_Proc_GO