SQL存储过程一些常用方法

通过参数给表添加增加新列，@value3为新增列名

ALTER  proc pr_InsertIntoInitDataGridView
@value1 varchar(50),
@value2 varchar(50),
@value3 varchar(50),
@value4 varchar(50),
@value5 bit,
@value6 int,
@value7 bit,
@value8 int
as
declare @sql varchar(100)
Insert into InitDataGridView Values(@value1,@value2,@value3,@value4,@value5,@value6,@value7,@value8)
IF @value1='Student'
begin
set @sql='Alter table Student add ['+@value3+'] varchar(50) default(0)'
exec (@sql)
end
else
if @value1='Organize'
begin
set @sql='Alter table Organize add ['+@value3+'] varchar(50) default(0)'
exec (@sql)
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO