关于存储过程和触发器的问题!
我有A表,里面有一insert触发器向B表插入数据;另外A有一个插入此表数据的存储过程。当存在触发器的时候存储过程中的update不起作用,没有触发器的时候Update起作用。请问是什么原因??
存储过程如下:
CREATE PROCEDURE InsertEmployee
@EmployeeName NVARCHAR(8) = NULL,
@Sex NVARCHAR(2) = NULL
AS
SET NOCOUNT ON
-- Insert the new Employee and then return the
-- new Employee_ID (Nvarchar)
INSERT Employee (EmployeeName, Sex
SELECT @EmployeeName, @Sex
-- return Employee_ID for new Employee record
UPDATE Employee SET Employee_ID=RIGHT('00000'+CAST(Auto_Value as varchar),5) WHERE Auto_Value = @@IDENTITY
RETURN 0
------------------------------------------------
GO
触发器如下
CREATE TRIGGER insertuseraccount ON [dbo].[Employee]
FOR INSERT
AS
insert into useraccount (UserName) select RIGHT('00000'+CAST(Auto_Value as varchar),5) from inserted