CREATE PROCEDURE spEmployee_AddField
(
@intLength int,
@chvField varchar(200)
)
ASexec('ALTER TABLE dbo.[Employee] ADD'+@chvField+' varchar(20) NOT NULL')
GO
(
@intLength int,
@chvField varchar(200)
)
ASexec('ALTER TABLE dbo.[Employee] ADD'+@chvField+' varchar(20) NOT NULL')
GO
(
@intLength int,
@chvField varchar(200)
)
AS
declare @a varchar(8000)
set @a='ALTER TABLE dbo.[Employee] ADD'+@chvField+' varchar('+cast(@intlenght as varchar(10))+') NOT NULL'exec(@a)
GO
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: 'varchar' 附近有语法错误。
(
@intLength int,
@chvField varchar(200)
)
AS
exec ('ALTER TABLE dbo.[Employee] ADD'+@chvField+' varchar('+cast(@intlength as varchar(10))+') NOT NULL')GO