SQL Server - after insert trigger - update another column in the same table - Stack Overflow

SQL Server - after insert trigger - update another column in the same table - Stack Overflow

瀏覽:1287
日期:2026-04-21
I've got this database trigger: CREATE TRIGGER setDescToUpper ON part_numbers AFTER INSERT,UPDATE AS DECLARE @PnumPkid int, @PDesc nvarchar(128) SET @PnumPkid = (SELECT pnum_pkid FROM inserted) ... ... Another option would be to ......看更多