select
A.serialno,
dbo.f_get_serialno_desc('EP',A.serialno,8) as serialno_desc,
A.product_no,
A.bom_no,
case when isnull(E.name_desc,'')!='' then E.name_desc else C.name_desc end as sys_applyer_id,
B.problem_desc,
B.reason_analysis,
B.solution,
B.expect_date,
B.charge_person,
B.complet_date,
B.complate_person,
case A.sys_state when 'Y' then '批核通過'
when 'R' then ('待'+isnull(D.subflow_desc,'批核'))
else '批核不通過' end as sys_state
from ep_meeting_hd A
left join CRC_LogDB B on A.product_no= B.product_no
left join pass_hd_leave C on A.sys_applyer_id=C.user_name
left join Workflow_Form_Flow_Template_Detail D on A.sys_subflow_id=D.subflow_id
left join pass_hd E on A.sys_applyer_id=E.user_name
這個語句我在SQl2005中運行沒錯誤可以查處數據,但是我在C#中把這跳語句綁定到DataGrid中來查詢數據為什麼會出錯:說什麼(Failed to enable constraits, one or more row contain violating non-null,unique or foreign-key contstraints) 不知道是什麼原因
我沒分了 請你們幫我看看 謝謝 。。
A.serialno,
dbo.f_get_serialno_desc('EP',A.serialno,8) as serialno_desc,
A.product_no,
A.bom_no,
case when isnull(E.name_desc,'')!='' then E.name_desc else C.name_desc end as sys_applyer_id,
B.problem_desc,
B.reason_analysis,
B.solution,
B.expect_date,
B.charge_person,
B.complet_date,
B.complate_person,
case A.sys_state when 'Y' then '批核通過'
when 'R' then ('待'+isnull(D.subflow_desc,'批核'))
else '批核不通過' end as sys_state
from ep_meeting_hd A
left join CRC_LogDB B on A.product_no= B.product_no
left join pass_hd_leave C on A.sys_applyer_id=C.user_name
left join Workflow_Form_Flow_Template_Detail D on A.sys_subflow_id=D.subflow_id
left join pass_hd E on A.sys_applyer_id=E.user_name
這個語句我在SQl2005中運行沒錯誤可以查處數據,但是我在C#中把這跳語句綁定到DataGrid中來查詢數據為什麼會出錯:說什麼(Failed to enable constraits, one or more row contain violating non-null,unique or foreign-key contstraints) 不知道是什麼原因
我沒分了 請你們幫我看看 謝謝 。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货