运行带参数外部程序的触发器如何写
昨天开始认识触发器,今天问题来了:
触发器调用外部程序,但是发现执行是的参数是字符@c,@n,@p,未能将记录内容带入,帮忙查下原因
CREATE TRIGGER JMUP ON [dbo].[Area]
FOR INSERT
AS
BEGIN
declare @c varchar(30)
declare @n varchar(30)
declare @p varchar(30)
select @c=id,@n=name,@p=code from inserted
EXEC master..xp_cmdshell 'D:\Project1 1 a @c @n @p'
END
问题点数：50、回复次数：1Top
1 楼wgsasd311（自强不息）回复于 2006-03-04 21:01:09 得分 50
CREATE TRIGGER JMUP ON [dbo].[Area]
FOR INSERT
AS
BEGIN
declare @c varchar(30)
declare @n varchar(30)
declare @p varchar(30)
select @c=id,@n=name,@p=code from inserted
exec(' master..xp_cmdshell ''D:\Project1 1 a '+@c+' '+@n+' '+@p+'''')
ENDTop
