27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER fitemss97_Insert ON fitemss97
FOR insert
as
BEGIN
DECLARE @I_id int --档案 ID
DECLARE @citemname nvarchar(60)
DECLARE xhw_aut CURSOR FOR
SELECT I_id,citemname FROM inserted
open xhw_aut
FETCH xhw_aut into @I_id,@citemname
while @@FETCH_STATUS = 0
begin
update fitemss97
set citemname=substring(dbo.fitemss97.citemname,0,51)
where I_id=@I_id
FETCH xhw_aut into @I_id,@citemname
end
CLOSE xhw_aut
DEALLOCATE xhw_aut
END