none
在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。) RRS feed

  • 问题

  • 在SQL Server服务器本地执行下面的代码也是报上面的错误,并且会断开连接,之前是好用的,最近才出现的问题。请帮忙,非常感谢。

    insert into tmpZSD0601_c 

    select tc.TPDetail_ID,tc.Activity_Description,tc.cpycode,tc.Custom_ID,tc.RebateA_Type,tc.RebateCC_Type,tc.CPT_ID,tc.CPT_Description,tlu.Settle_Money as RebateC_Total,tc.Settle_Total,tc.Settle_Money,tc.Create_Date,tc.Modify_Date,tc.RebateSC_Way
    from tmpZSD0601_c_LN_update as tc inner join tmpZSD0601_LN_Update as tlu on tc.TPDetail_ID=tlu.TPDetail_ID and tc.Custom_ID=tlu.Custom_ID and tc.RebateCC_Type=tlu.RebateCC_Type
    union all
    select tc1.TPDetail_ID,tc1.Activity_Description,tc1.cpycode,tc1.Custom_ID,tc1.RebateA_Type,tc1.RebateCC_Type,tc1.CPT_ID,tc1.CPT_Description,tc1.RebateC_Total,tc1.Settle_Total,tc1.Settle_Money,tc1.Create_Date,tc1.Modify_Date,tc1.RebateSC_Way
    from tmpZSD0601_c_LN_update as tc1 where tc1.TPDetail_ID+tc1.Custom_ID+tc1.RebateCC_Type not in (
    select tlu1.TPDetail_ID+tlu1.Custom_ID+tlu1.RebateCC_Type from tmpZSD0601_LN_Update as tlu1 )

    2018年4月25日 1:03

全部回复