It turned out all right, but since a trigger was added to the SQL database, I got an error and couldn't figure it out ?

pantao999

Check the field parameters used by the trigger. It may be null in the existing or in use

zhy889900

If I change that field (field related to the trigger) in the SQL Query Analyzer, the execution of the trigger is normal and no error is reported, but it will report an error when running in EJB

zhy889900

After someone pointed me, my trigger was changed to the following:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER trigger T_update_trans

on transinfo
for update
as
--Out of service transformer, the outage information table is maintained by the trigger
begin

  if update(booknum)
  begin
  update userinfo set booknum = b.booknum
  from userinfo a,inserted b
  where a.substaid = b.substaid and a.lineid = b.lineid and a.transid = b.transid
  end
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

In addition, in the userinfo table changed by this trigger, there is also a trigger, which is also a trigger for the booknum field