一个触发器
摘要：
ALTER Trigger [trig_ensure_injury]on [dbo].[Employee_basic_infomation]After insertasDeclare @Injury_status nvarchar(50)Select @injury_status=injury_status from insertedif @injury_status is nullBegin update dbo.Employee_basic_infomation Set injury_status='未保' From Employee_basic_infomation e 阅读全文
posted @ 2012-04-12 20:04 遗忘海岸 阅读(216) 评论(0) 推荐(0) 编辑