CREATE PROC spAddColumn
(
@TableName VARCHAR(50),
@ColName VARCHAR(50),
@Type VARCHAR(50)
)
AS
SET NOCOUNT ONDECLARE @vSql VARCHAR(8000)
SET @vSql = '
ALTER TABLE [' + @TableName + ']
ADD [' + @ColName + '] ' + @TypeEXEC(@vSql)
GO
(
@TableName VARCHAR(50),
@ColName VARCHAR(50),
@Type VARCHAR(50)
)
AS
SET NOCOUNT ONDECLARE @vSql VARCHAR(8000)
SET @vSql = '
ALTER TABLE [' + @TableName + ']
ADD [' + @ColName + '] ' + @TypeEXEC(@vSql)
GO
(
@tablen char(50),
@Coln char(50)
)
AS
DECLARE @Sql VARCHAR(8000)
SET @vSql = '
ALTER TABLE ' + @TableName + '
ADD ' + @ColName + ' 'EXEC(@Sql)
GO