更新两个表的信息 [英] update the information for two tables

问题描述

leave_type表应用表制裁表留下详细信息表



leavetypeid empid empid empid

leavetypename startdate leavetype totalleave

noofleaves enddate noofleaves leavetype

leavetype status usedleave

noofleaes remainingleave



allignment不合适第一行是第一个表就像leave_type表一样，表中的其余部分



在此离开管理项目中，一旦根据状态请求批准休假后将应用程序发送到hod或拒绝保留详细信息表中存储的所有休假信息，如剩余休假，使用休假...每次升级时使用休假...请写下查询。

leave_type table application table sanction table leave details tabel

leavetypeid empid empid empid
leavetypename startdate leavetype totalleave
noofleaves enddate noofleaves leavetype
leavetype status usedleave
noofleaes remainingleave

allignment is not proper first row is the first table like leave_type table like rest of the table

in this leave managmnt project, once application is sent to the hod after approving the leave depending on the status request or reject all the leave information stored in the leave details table like remaing leave,used leave... used leave each time upgrade... please write the query for that.

解决方案

请在您的休假桌上尝试以下触发器（您将在其中更新您的休假状态）

Hi,
Please try below trigger on your leave table (in which you are going to updated your Leave Status)

Create Trigger UpdateLeaveDetails on [Leave]
For update
as
Declare @empid int;
Declare @LeaveStatus int;

select @empid=i.Emp_ID from inserted i;	
select @LeaveStatus=i.LeaveStatus from inserted i;

if (@LeaveStatus == 1)  -- 1 for approve
		UPDATE LeaveDetails SET remaing_leave = remaing_leave-1 ,used_leave = used_leave-1 where empid = @empid
		
	-- No Need to update LeaveDetails information if leave are rejected  
GO 

您可以使用触发器更新两个表。

Hi,
You can use trigger to update two tables.

这篇关于更新两个表的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！