select syscolumns.[name] from syscolumns,sysobjects
where syscolumns.[id]=sysobjects.[id] and sysobjects.[name]='Orders'
alter table a alter column id dec(10,1) //更改表a中得id字段为dec(10,1)类型
select syscolumns.[name] from syscolumns,sysobjects
where syscolumns.[id]=sysobjects.[id] and sysobjects.[name]='Orders'
alter table a alter column id dec(10,1) //更改表a中得id字段为dec(10,1)类型