SQLServer触发器的问题
想在执行批量执行插入语句的时候，先清除该表中的所有数据。
create trigger del
on dbo.t
instead of insert
as
delete from dbo.t
go
这是我写的触发器，请大神指教。
[解决办法]
create trigger del
on dbo.t
instead of insert
as
delete from dbo.t
insert dbo.t select * from inserted
go
[解决办法]
