create trigger trigger_name ON table_name FOR update,insert if update(column_name) begin update table_name set column_name='是' from column_name,updated where column_name.id=updated.id and right(updated.column_name,2) != '/月' end
这个人说的比较对 marco08(天道酬勤) ( ) 信誉:100 Blog 2006-12-14 17:08:48 得分: 0
ON table_name
FOR update,insert
if update(column_name)
begin
update table_name
set column_name='是'
from column_name,updated where column_name.id=updated.id
and right(updated.column_name,2) != '/月'
end
最好在 SELECT 時加