摘要：ALTER TRIGGER test_Rate ON dbo.tRate FOR insert AS declare @errno int, @errmsg varchar(255) begin UPDATE dbo.tRate SET vcUpdaterId=Inserted.iAutoId FROM dbo.tRate, inserted W...
阅读全文
posted @ 2018-04-18 14:54
04 2018 档案
摘要：T-Sql 递归查询（给定节点查所有父节点、所有子节点的方法） -- 查找所有父节点with tab as( select Type_Id,ParentId,Type_Name from Sys_ParamType_V2_0 where Type_Id=316--子节点 union all sele
阅读全文
posted @ 2018-04-04 12:42
