当然可以了。。/
CREATE TRIGGER [Update_zxzxrefer_table]
ON [dbo].[zxzx_referback]
FOR INSERT,UPDATE ,DELETE
as
begin
end
CREATE TRIGGER [Update_zxzxrefer_table]
ON [dbo].[zxzx_referback]
FOR INSERT,UPDATE ,DELETE
as
begin
end
调试欢乐多
ON [dbo].[zxzx_referback]
FOR INSERT, DELETE
AS
begin
update zxzx_refer set 状态=1 from zxzx_refer,inserted where inserted.id =zxzx_refer.id
delete zxzx_refer from zxzx_refer,deleted where zxzx_refer.id=deleted.id
end
你可以先导入到TEMPTABLKE
bcp DB_NAME.dbo.TEMPTABLE in c:\mytable_bcp.txt-c -q -S"servername" -U"sa" -P""
然后
insert into mytable(....) select(id+50000,.....) from temptable
2:先导入SQL后,再用SQL来处理就简单了。