日期:2014-05-17 浏览次数:20459 次
ALTER TRIGGER "tr_cust_order_in" on
dba.cust_order for insert
/* Watcom only
order 2
*/
/* Watcom only
for each row
*/
as
begin
update cust_order set
create_time = getdate(*)
where cust_order.trans_no = new_cust_order.trans_no
end
select case when DATEPART(hh,getdate())<12 then '上午' else '下午' end
update cust_order set
create_time = getdate(*)
,case when time()=小于12:00 then user_3=“早上”
when time()=大于12:00 then user_3='下午“ end
where cust_order.trans_no = new_cust_order.trans_no
update cust_order set
create_time = getdate(*)
,user_3=case when time()=小于12:00 then “早上”
when time()=大于12:00 then '下午“ end
where cust_order.trans_no = new_cust_order.trans_no