触发器
alter TRIGGER [dbo].[copy_regcard]
ON [dbo].[reg_signcard] for insert
as
begin
insert tmpTRecords(emp_id,card_id,sign_time) select emp_id,emp_id,sign_time from inserted
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO其中表tmpTRecord 中还有一个列为clock_id,我想在插入数据同时在该列填上一个数字 5
alter TRIGGER [dbo].[copy_regcard]
ON [dbo].[reg_signcard] for insert
as
begin
insert tmpTRecords(emp_id,card_id,sign_time) select emp_id,emp_id,sign_time from inserted
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO其中表tmpTRecord 中还有一个列为clock_id,我想在插入数据同时在该列填上一个数字 5
ON [dbo].[reg_signcard] for insert
as
begin
insert tmpTRecords(emp_id,card_id,sign_time,clock_id)
select emp_id,emp_id,sign_time,5 from inserted
END
ON [dbo].[reg_signcard] for insert
as
begin
insert tmpTRecords(emp_id,card_id,sign_time,clock_id) select emp_id,emp_id,sign_time,5 from inserted
END
go
如果是常量直接写就可以了
ON [dbo].[reg_signcard] for insert
as
begin
insert tmpTRecords(emp_id,card_id,sign_time) select emp_id,emp_id,sign_time,5from inserted
END
ON [dbo].[reg_signcard] for insert
as
begin
insert tmpTRecords(emp_id,card_id,sign_time) select emp_id,emp_id,sign_time,5 from inserted
END