|
发表于 2009-1-14 11:15:12
|
显示全部楼层
本帖最后由 sxmzsl 于 2009-1-14 11:26 编辑
结转失败:复制HR对象 failed
Microsoft SQL-DMO (ODBC SQLState: 42S02)
[Microsoft][ODBC SQL Server Driver][SQL Server]对象名 'hr_v_tr_rescol' 无效。
这个hr_v_tr_rescol是视图表,我查询了一下内容为空,没有记录。怎么解决呀
根据以下语句生成
CREATE view hr_v_tr_rescol as
select ccodeid,vdescription ,ccodeid as ext,'1' as restype from HR_CT210
union
select cast(pk_hr_tr_teacher as varchar(100)) as ccodeid ,vteachername as vdescription,vteachercode as ext,'2' as restype from hr_tr_teacher
union
select cast (pk_hr_tr_subject as varchar(100)) as ccodeid,vsubjectname as vdescription ,vsubjectcode as ext,'3' as restype from hr_tr_subject |
|