CREATE TABLE [dbo].[atest] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TRIGGER ENCRYPT_TRIGGER on atest
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO atest SELECT id,name,encrypt (password) FROM inserted
END
GO
insert into atest(name,password) values('yyy','yyy')
go
select * from a
go
结果:ID NAME PASSWORD
1 YYY YYY
为什么会这样?