试试: ------------------------------------------------------------------------------ alter trigger tr_insert on TRADE instead of insert as insert into TRADE select * from inserted EXEC master..xp_cmdshell 'bcp TRADE out c:\temp1.xls -c -q -S"DL" -U"sa" -P"1"' go
libin_ftsafe(子陌红尘)的方法不行,一样堵塞。这样: create trigger tr_insert on TRADE for insert as commit tran --提交事务 EXEC master..xp_cmdshell 'bcp TRADE out c:\temp1.xls -c -q -S"DL" -U"sa" -P"1"' go
------------------------------------------------------------------------------
alter trigger tr_insert on TRADE
instead of insert
as
insert into TRADE select * from inserted
EXEC master..xp_cmdshell 'bcp TRADE out c:\temp1.xls -c -q -S"DL" -U"sa" -P"1"'
go
create trigger tr_insert on TRADE
for insert
as
commit tran --提交事务
EXEC master..xp_cmdshell 'bcp TRADE out c:\temp1.xls -c -q -S"DL" -U"sa" -P"1"'
go
SQLServer在启动触发器时会自动开启一个事务,所以在触发器里最好先Commit一下,把这个事务提交了,这样对原表的lock也就释放了。