----增加字段
create proc pro_add (@pointInfo char (10) )
as
exec(
'alter table tb add '+@pointInfo+' int')
----删除字段
create proc pro_del (@pointInfo char (10) )
as
exec(
'ALTER TABLE tb DROP COLUMN '+@pointInfo+'')
create proc pro_add (@pointInfo char (10) )
as
exec(
'alter table tb add '+@pointInfo+' int')
----删除字段
create proc pro_del (@pointInfo char (10) )
as
exec(
'ALTER TABLE tb DROP COLUMN '+@pointInfo+'')
----增加字段
create proc pro_add (@pointInfo varchar (10) )
as
exec(
'alter table tb add '+@pointInfo+' int')
----删除字段
create proc pro_del (@pointInfo varchar (10) )
as
exec(
'ALTER TABLE tb DROP COLUMN '+@pointInfo+'')