22,207
社区成员
发帖
与我相关
我的任务
分享
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
go
alter PROCEDURE UpdateEmployeeSalary
@EmployeeID int,
@UpdateSalaryNumber DECIMAL(18,2) = 0
AS
BEGIN
UPDATE dbo.EmployeeSalary SET Salary = @UpdateSalaryNumber WHERE EmployeeID = @EmployeeID
UPDATE dbo.PayOut SET PayOut = @UpdateSalaryNumber WHERE EmployeeID = @EmployeeID
SET NOCOUNT ON;
END
GO