谁帮我写个UPDATE的触发器(sq2000 sp4)

来源：百度知道 编辑：UC知道 时间：2024/05/16 16:20:07
这个是一条语句操作
insert into emp
(GUID, DEPT_ID, EMP_NAME, EMP_SP,
INTIME, SEX, CSNY, MZ, CARD_TYPE, CARD_NUM,
ADDRESS, XL, JG, DJ_REASON, UPLOAD_TIME,
IS_UPLOAD, OUTTIME, ENT_ID,
EXT_ID, SID,
FRONT_INSERT_TIME,
BACK_INSERT_TIME)
values
(144000001,'','','',
'','','','','','',
'',null,'','','',
null,'','',
'','',
'','')

update emp SET
DEPT_ID='E5CC2D73-5626-4AB5-8FC0-BF5798394658',EMP_NAME='名字',

EMP_SP='MZ',
INTIME='2008-1-1', SEX='男', CSNY='1980-1-1', MZ='汉族', CARD_TYPE='二

代证', CARD_NUM='130702198003081237',
ADDRESS='地址',XL='', JG='籍贯', DJ_REASON='入职', UPLOAD_TIME='2008-5-

1',

问题看不明白。你的意思是不是，当插入一条记录到emp，就要修改emp中相同GUID的记录。假设guid的数据类型是varchar(50)。
create trigger emp_INSERT on emp
after insert
as
declare @guid varchar(50)
set @guid =(select guid from inserted)
update emp SET
DEPT_ID='E5CC2D73-5626-4AB5-8FC0-BF5798394658',EMP_NAME='名字',

EMP_SP='MZ',
INTIME='2008-1-1', SEX='男', CSNY='1980-1-1', MZ='汉族', CARD_TYPE='二

代证', CARD_NUM='130702198003081237',
ADDRESS='地址',XL='', JG='籍贯', DJ_REASON='入职', UPLOAD_TIME='2008-5-

1',
IS_UPLOAD=3, OUTTIME='1900-1-1', ENT_ID='121100000001',
EXT_ID='000', SID='121100000001-000@20080402-103833-869',
FRONT_INSERT_TIME='2008-5-1',
BACK_INSERT_TIME='2008-5-1' where GUID=@guid