CREATE TRIGGER tr_InsBBTB ON dbo.aaTB AFTER INSERT,UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here INSERT INTO dbo.bbTB ( id, UserID, UserName ) SELECT id, UserID, UserName FROM inserted END GO
想在表aaTb的基础上,更新出一张新的表bbTb
bbTb
ON dbo.aaTB
AFTER INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON; -- Insert statements for trigger here
INSERT INTO dbo.bbTB
( id, UserID, UserName )
SELECT id, UserID, UserName FROM inserted
END
GO
用sql server的作业
用sql server的作业
请问sql 代理作业 步骤下的命令不能识别.bat脚本,导致作业失败!!
要怎么让命令成功执行.bat呢?
要怎么让命令成功执行.bat呢?
exec master..xp_cmdshell '[路径]\[文件名].bat'
exec master..xp_cmdshell '[路径]\[文件名].bat'
谢谢!
现在我知道了这个方法的运用,可是问题:“如何将数据库里边的一张表(aaTb)进行随时更新出一张新表(bbTb),新表bbTb里面保有之前表aaTb字段的空记录以代替aaTb来做数据存储工作任务,然后表aaTb停止存储任务。”还不懂得怎么写一个bat文件。