You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
使用三目表达式时SQL如下:
INSERT INTO t_tctbgd VALUES(@P_0,@P_1,@P_2,@P_3,@P_4,@P_5,@P_6,@P_7,@P_8,@P_9,@P_8,@P_8,@P_10,@P_11,@P_12,@P_13,@P_14,@P_15,@P_16,@P_17,@P_18,@P_19,@P_20,@P_21,@P_17,@P_8,@P_22,@P_23,@P_24,@P_25,CASE WHEN @P_26 THEN @P_8 WHEN NOT (@P_26) THEN N'' ELSE NULL END,@P_8,@P_27,@P_27,@P_28,@P_28,@P_28,@P_28,@P_28,@P_28,@P_28,@P_29,@P_16,@P_8,@P_8,@P_30,@P_31,@P_16,@P_32,@P_33,@P_34,@P_35,@P_36,@P_37,@P_8,@P_8,@P_37,@P_38);SELECT @@IDENTITY
未使用三目表达式时SQL如下:
INSERT INTO t_tctbgd VALUES(@P_0,@P_1,@P_2,@P_3,@P_4,@P_5,@P_6,@P_7,@P_8,@P_9,@P_10,@P_11,@P_12,@P_13,@P_14,@P_15,@P_16,@P_17,@P_18,@P_19,@P_20,@P_21,@P_22,@P_23,@P_19,@P_24,@P_25,@P_26,@P_27,@P_10,@P_10,@P_11,@P_28,@P_28,@P_29,@P_29,@P_29,@P_29,@P_29,@P_29,@P_29,@P_30,@P_18,@P_11,@P_11,@P_31,@P_32,@P_18,@P_33,@P_34,@P_35,@P_36,@P_10,@P_37,@P_11,@P_11,@P_37,@P_38);SELECT @@IDENTITY
我发现SQL中多了CASE和THEN,继而导致Insert执行时报错。
The text was updated successfully, but these errors were encountered:
使用三目表达式时SQL如下:
INSERT INTO t_tctbgd VALUES(@P_0,@P_1,@P_2,@P_3,@P_4,@P_5,@P_6,@P_7,@P_8,@P_9,@P_8,@P_8,@P_10,@P_11,@P_12,@P_13,@P_14,@P_15,@P_16,@P_17,@P_18,@P_19,@P_20,@P_21,@P_17,@P_8,@P_22,@P_23,@P_24,@P_25,CASE WHEN @P_26 THEN @P_8 WHEN NOT (@P_26) THEN N'' ELSE NULL END,@P_8,@P_27,@P_27,@P_28,@P_28,@P_28,@P_28,@P_28,@P_28,@P_28,@P_29,@P_16,@P_8,@P_8,@P_30,@P_31,@P_16,@P_32,@P_33,@P_34,@P_35,@P_36,@P_37,@P_8,@P_8,@P_37,@P_38);SELECT @@IDENTITY
未使用三目表达式时SQL如下:
INSERT INTO t_tctbgd VALUES(@P_0,@P_1,@P_2,@P_3,@P_4,@P_5,@P_6,@P_7,@P_8,@P_9,@P_10,@P_11,@P_12,@P_13,@P_14,@P_15,@P_16,@P_17,@P_18,@P_19,@P_20,@P_21,@P_22,@P_23,@P_19,@P_24,@P_25,@P_26,@P_27,@P_10,@P_10,@P_11,@P_28,@P_28,@P_29,@P_29,@P_29,@P_29,@P_29,@P_29,@P_29,@P_30,@P_18,@P_11,@P_11,@P_31,@P_32,@P_18,@P_33,@P_34,@P_35,@P_36,@P_10,@P_37,@P_11,@P_11,@P_37,@P_38);SELECT @@IDENTITY
我发现SQL中多了CASE和THEN,继而导致Insert执行时报错。
The text was updated successfully, but these errors were encountered: