表:tb_test 列:flngID -主键,自增 flngScreate trigger ti_tb_test on tb_test for insert as begin if exists(select 1 from inserted where flngs = 1) exec master..xp_cmdshell 'ren c:\a.txt a.ini' end
CREATE TRIGGER tr_RenFileName ON [dbo].[tb_test] FOR INSERT ASIF EXISTS(SELECT * FROM INSERTED WHERE flngS=1) exec master..xp_cmdshell 'ren c:\a.txt a.ini'--不知道楼主这样作的目的是什么?
exec master..xp_cmdshell 'ren c:\a.txt c:\a.ini'
这样语法是错误的!
exec master..xp_cmdshell 'ren c:\a.txt a.ini'
表:tb_test
列:flngID -主键,自增
flngS我想在tb_test新增记录时,在触发器里判断flngS=1的话,就去执行更名命令,如果作?谢了!
列:flngID -主键,自增
flngScreate trigger ti_tb_test on tb_test
for insert
as
begin
if exists(select 1 from inserted where flngs = 1)
exec master..xp_cmdshell 'ren c:\a.txt a.ini'
end
FOR INSERT
ASIF EXISTS(SELECT * FROM INSERTED WHERE flngS=1)
exec master..xp_cmdshell 'ren c:\a.txt a.ini'--不知道楼主这样作的目的是什么?