In the below example, I want to insert all records. But during insertion C_Is_LumpSum field is taken empty.
I need to avoid empty record in the column C_Is_LumpSum.
Note : This table already having data with the column C_Is_LumpSum having some empty field. Hereafter I want to insert value in the column C_Is_LumpSum.
IF EXISTS (select I_Student_ID, I_Batch_ID, C_Is_LumpSum from dbo.T_Student_Batch_Details where C_Is_LumpSum != '')
INSERT INTO dbo.T_Student_Batch_Details (
) VALUES (