摘要:
创建一个触发器 CREATE TRIGGER decor--触发器名称 ON dbo.SG_DecorationEntry --表名 AFTER INSERT --操作(增删改) AS BEGIN DECLARE @id UNIQUEIDENTIFIER SELECT @id=Inserted.De 阅读全文
摘要:
将‘0654879’替换成‘0754879’ UPDATE dbo.SG_Functionality SET FunctionalityCode=REPLACE(FunctionalityCode,'06','07') WHERE Type=2 AND FunctionalityCode LIKE 阅读全文