I don't know <IsNotNull Property=""D0T01"">, D0_T1 = @D0T01</IsNotNull>
C#:
CREATE PROCEDURE [dbo].[Update_HI_ERP_PLAN]
@PLANT_CODE varchar(50),
@PLAN_DATE varchar(50),
@PRODUCT_CODE varchar(50),
@USERID varchar(50)
AS
BEGIN
UPDATE HI_ERP_PLAN
SET
ERP_PLAN_UDF_9 = CASE WHEN ERP_PLAN_UDF_9 = 'Y' THEN 'U' END,
UPDATE_TIME = dbo.Get_DATETIME(),
UPDATE_USER = 'ME'
<IsNotNull Property=""D0T01"">, D0_T1 = @D0T01</IsNotNull>
<IsNotNull Property=""D0T02"">, D0_T2 = @D0T02</IsNotNull>
<IsNotNull Property=""D0T03"">, D0_T3 = @D0T03</IsNotNull>
<IsNotNull Property=""D0T04"">, D0_T4 = @D0T04</IsNotNull>
<IsNotNull Property=""D0T05"">, D0_T5 = @D0T05</IsNotNull>
WHERE PLANT_CODE = 'ABC'