通过脚本添加字段不成功

[jashionqq]

/*create table test(
lxh int,
msg varchar(80)
)
*/

if not exists (select name from syscolumns where id = object_id('test') and name = 'ss')
begin
alter table test add ss int default(0);
update test set ss = lxh;
end;
执行脚本后报错，报错信息如下：
消息 207，级别 16，状态 1，第 0 行
列名 'ss' 无效。
另：if not exists (select name from syscolumns where id = object_id('test') and name = 'ss')
begin
alter table test add ss int default(0);
--update test set ss = test.lxh;
end;
执行这句脚本是成功的

[jashionqq]

感谢simonxt的回复，按照你的做法就成功了，谢谢。

[simonxt]

if not exists (select name from syscolumns where id = object_id('test') and name = 'ss')  
begin
  alter table test add ss int default(0);
  exec('update test set ss = lxh;')
end;

这样呢？

[TracyLeebaihe]

if not exists (select name from syscolumns where id = object_id('test') and name = 'ss')  
alter table test add ss int default(0);
go
update test set ss = [入库];
go

这样保你成功

[wujianfeng32]

ss=''