declare @a varchar(255)
set @a='col1'CREATE TABLE doc_exa ( column_a INT)
GO
exec('ALTER TABLE doc_exa ADD '+@a+' VARCHAR(20) NULL')
GO
EXEC sp_help doc_exa
GO
DROP TABLE doc_exa
GO
set @a='col1'CREATE TABLE doc_exa ( column_a INT)
GO
exec('ALTER TABLE doc_exa ADD '+@a+' VARCHAR(20) NULL')
GO
EXEC sp_help doc_exa
GO
DROP TABLE doc_exa
GO
GOdeclare @a varchar(255)
set @a='col1'
exec('ALTER TABLE doc_exa ADD '+@a+' VARCHAR(20) NULL')
GO
EXEC sp_help doc_exa
GO
DROP TABLE doc_exa
GO
set @str = 'ALTER TABLE doc_exa ADD ' + @a + ' VARCHAR(20) NULL'exec @str
---OK 啦
GO
declare @a varchar(255)
set @a='col1'
Exec('ALTER TABLE doc_exa ADD '+@a+' VARCHAR(20) NULL ')
GO
EXEC sp_help ypatvisit
GO
DROP TABLE doc_exa