请帮助：如何通过存储过程动态增加MS SQL SERVER 表的字段？

[wedding]

CREATE PROCEDURE Fiels_Insert @fieldname char(40)
AS
BEGIN TRANSACTION
我如下写
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.test ADD
@fieldname char(10) NULL
COMMIT
GO

当语法检查就通不过，请帮助。

[flyingkiller]

try
Declare @sql varchar(200);
set @sql='ALTER TABLE dbo.test ADD '+@fieldname+' char(10) NULL';
exec(@sql);

[enewren]

最好加个事务处理！