| 解决方案： |
请参照如下脚本将正常帐套中的记录导入到当前帐套年度库中即可： SET IDENTITY_INSERT fitemstructure ON GO INSERT INTO [UFDATA_106_2006].[dbo].[fitemstructure]([i_id], [citem_class], [citem_sqr], [cfield_name], [ctext], [imode], [itype], [ilength], [iscale], [blist], [bsum], [bRef], [iSubItem], [iDefine], [bPrimaryKey], [iSource], [cTableName], [cFieldName], [bOrderBy]) select [i_id], [citem_class], [citem_sqr], [cfield_name], [ctext], [imode], [itype], [ilength], [iscale], [blist], [bsum], [bRef], [iSubItem], [iDefine], [bPrimaryKey], [iSource], [cTableName], [cFieldName], [bOrderBy] from ufdata_306_2006..fitemstructure WHERE citem_class = '98' GO SET IDENTITY_INSERT fitemstructure OFF GO 修改前请务必做好数据备份！ 【注意事项】 注意根据实际数据库修改脚本中的数据库参数。 |