oer

摘要： 怎样将数据库中所有表中含有numeric(18,2)字段改成numeric(18,10)declare c cursorforselect'alter table ['+ a.name +'] alter column ['+b.name+'] numeric(18,10);'from sysobjects a,syscolumns b,systypes c where a.id=b.id and b.xtype=c.xtype and a.type='u' and b.xprec=18 and b.xscale=2 and c. 阅读全文