随笔分类 -  SQL

摘要：WITHTREE AS( SELECT a.FItemID cfitemid,b.FItemID pfitemid FROM dbo.ICBOMChild a,dbo.ICBOM b WHERE a.FInterID = b.FInterID and a.FInterID = 1320 -- 要查询 阅读全文

摘要：--临时表 IF OBJECT_ID('tempdb..#Entry') is not null BEGIN DROP TABLE #Entry END --创建触发器 ALTER TRIGGER [dbo].[icstockbill_ins] ON [dbo].[ICStockBill] AFTE 阅读全文