代碼如下:
1 CREATE procedure usp_wage_emp_del @emp_sn as smallint as
2 begin transaction
3 insert into history_employee select * from employee where emp_sn = @emp_sn
4 insert into history_wage select * from uv_wage_idcard where emp_idcrad = @emp_sn
5 delete employee where emp_sn =@emp_sn
6 delete wage where emp_sn = @emp_sn
7 commit transaction
--------------------------------------------------------
有趣現像在4行,因into表行太多,所以作了個和into表一樣的視圖,
但在寮際的執行過程中,第4行好想什麼也沒執行。為什麼|?