select into 加字段的问题
select *, ' ' as winsys, ' ' as bro into temp_bro20070917 from [20070917]
执行报错 列 ‘winsys’的宽度 0 无效。
我想在表复制的时候直接多加2个字段进去可以吗?难道要复制表后再加字段吗?
[解决办法]
select *, cast( ' ' as varchar(10)) as [winsys], cast( ' ' as varchar(10)) as bro into temp_bro20070917 from syscolumns