And where is a
NULL
value?
Replace:
insert into InOutRegister values(@loccode,getdate(),convert(varchar, getdate(), 8),'',@remark)
with:
insert into InOutRegister (Field1, Field2, Field3, Field4, Field5) values(@loccode,getdate(),convert(varchar, getdate(), 8),NULL,@remark)