在asp.net中,想实现下面这个功能,有没有办法?select carorder from carorder_list_h where carorder_list_h002='000000001'
Update caryd_h Set carlistnum='000000001' where caryd_h002=上面的结果
Update caryd_h Set carlistnum='000000001' where caryd_h002=上面的结果
where caryd_h002=(select top 1 carorder from carorder_list_h where carorder_list_h002='000000001')