--try go if exists (select name from sysobjects where name='UP_DelColumn' and type='P') drop proc UP_DelColumn go create proc UP_DelColumn @num varchar(50), @kcnum varchar(50) as exec('alter table MAT_storage drop column '+@num) exec('alter table MAT_storage drop column '+@kcnum) go
--try
go
if exists (select name from sysobjects where name='UP_DelColumn' and type='P')
drop proc UP_DelColumn
go
create proc UP_DelColumn
@num varchar(50),
@kcnum varchar(50)
as
exec('alter table MAT_storage drop column '+@num)
exec('alter table MAT_storage drop column '+@kcnum)
go