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