摘要:
GO /****** Object: StoredProcedure [dbo].[Cargill_inventroyandPrice] Script Date: 7/2/2019 9:02:07 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[Cargill_inventr... 阅读全文
摘要:
select a.fname ,c.fname as fgroupname from t_user a inner join t_group b on a.FUserID =b.FUserID inner join #temp c on c.fuserid =b.FGroupID where a.FForbidden =0 order by a.fname selec... 阅读全文
摘要:
select FISKFPeriod, * from t_icitem where fnumber ='2.02.BZD023' update t_icitem set FISKFPeriod =1 where fnumber ='2.02.BZD023' select * from icinventory where fitemid =11683 阅读全文