谁知道10007错误是怎么回事儿?
数据库的一个表增加trigger后,出现10007错误,错误信息是:
General SQL Server Error: Check messages from the SQL Server.
触发器的代码如下:
CREATE trigger tg_sb_051
on dbo.t_sb_051
FOR UPDATE, INSERT
AS
BEGIN
select * into #temp from inserted
set rowcount 1
while exists (select * from #temp)
begin
insert into t_sb_052
(pjt_no, hogi_no, seq,
cret_day, cret_pern, mody_day, mody_pern )
select
pjt_no, hogi_no, (select isnull((max(seq) + 1), 1) from t_sb_052 A where A.pjt_no = X.pjt_no and A.hogi_no = X.hogi_no),
cret_day, cret_pern,
mody_day, mody_pern
FROM #temp x
delete from #temp
end
set rowcount 0
END