sp_bindefaultgongzi_defa,'月工资.zhufangbutie'5.创建触发器a.员工表中删除一条信息,其他表相应员工信息删除createtriggeremon员工fordeleteasdeletefrom考勤whereemp_noin(selectemp_nofromdeleted)deletefrom津贴whereemp_noin(selectemp_nofromdeleted)deletefrom月工资whereemp_noin(selectemp_nofromdeleted)验证:deletefrom员工whereemp_no='20070101'b.一个部门删除,此部门中的员工信息删除createtriggerbmon部门fordeleteasdeletefrom员工wheredepartment_idin(selectdepartment_idfromdeleted)验证:deletefrom部门wheredepartment_id='01'c.员工职务变动,基本工资改变createtriggerjbgzon员工forupdate,insertasdeclare@qvarchar(12)declare@mvarchar(12)declare@sfloatselect@q=emp_nofromDeletedselect@m=zhiwufromInsertedselect@s=jibengongzifrom基本工资wherezhiwu=@mupdate月工资setjibengongzi=@swhere月工资.Emp_no=@q6.创建函数a.函数查询员工基本信息createfunctionygxx(@yg_idvarchar(10))returnstableasreturn(select*from员工whereemp_no=@yg_id)验证:
全文预览
