Tuesday, June 23, 2009

Create stored procedure if doesn't exists in sysobjects

if not exists(Select * from sysobjects where name = 'ON_TIME_DELIVERY_TELCON2006')

begin

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE ON_TIME_DELIVERY_TELCON2006 AS

SELECT * FROM ACCOUNTS'

end

0 comments: