草庐IT

关于 sql:Msg 8114, Level 16, State 5, Procedure deepanshu_temp, Line 141 Error convert data type varchar to numeric

Msg8114,Level16,State5,Proceduredeepanshu_temp,Line141Errorconvertingdatatypevarchartonumeric我正在使用以下代码123456789101112131415161718192021(SELECT   CASE    WHEN[PRIMARYPlan]>0      THEN       CASE         WHEN[market_type]='WH'          THEN            CASE             WHEN@a>20               THEN1    

关于 sql:Msg 8114, Level 16, State 5, Procedure deepanshu_temp, Line 141 Error convert data type varchar to numeric

Msg8114,Level16,State5,Proceduredeepanshu_temp,Line141Errorconvertingdatatypevarchartonumeric我正在使用以下代码123456789101112131415161718192021(SELECT   CASE    WHEN[PRIMARYPlan]>0      THEN       CASE         WHEN[market_type]='WH'          THEN            CASE             WHEN@a>20               THEN1