<insert id="insertManuPlan" parameterClass="manuPlan">
insert into db_NLMRPII.dbo.t_manuPlan
(f_dtmDate,f_intBillerId,f_strNote) values(#date#,#biller.id#,#note#)
<selectKey resultClass="String" keyProperty="id">
select @@identity as id
</selectKey>
update db_NLMRPII.dbo.t_manuPlan set f_strNum=select @@identity
</insert>
10-06
10-06
10-06