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

瀏覽:1354
日期:2025-09-27
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 ......看更多