摘要:
use AISXXXXXgoif exists(select 1 where Convert(varchar(10),getdate(),120)=DATEADD(mm, DATEDIFF(mm,0,getdate()), 2) )beginupdate b set b.fallamount=V.f 阅读全文
摘要:
npm install -D babel-loader @babel/core @babel/preset-env webpack npm uninstall webpacknpm install webpack@^4.0.0 --save-dev 阅读全文
摘要:
Declare @CurYear Int, --当前年份 @CurPeriod int, --当前会计期间 @staryear int, --启用年份 @starperiod int, --启用期间 @totalmonth int --每个会计年度的总的期间数 Select @CurPeriod=F 阅读全文
摘要:
use AISXXXXXXXXXXXgoif exists(select 1 where Convert(varchar(10),getdate(),120)=DATEADD(mm, DATEDIFF(mm,0,getdate()), 2) )beginupdate b set b.fallamou 阅读全文
摘要:
select * from t_Mutex 阅读全文
摘要:
--清除发票记账标志 update ICPurchase set FPosted=null,FPosterID=null,FVchInterID=0 from ICPurchase where FBillNo='10083839' --清除库存单据记账标志 update icstockbill se 阅读全文
摘要:
declare @fuserid intselect @fuserid=fuserid from t_user where fname ='XXX' 根据情况修改delete b from ICClassFilterProfile a inner join ICClassFilterProfileE 阅读全文
摘要:
select t4.FNUMBER,t5.FNAME,t6.FNUMBER,t7.FNAME,t3.* from T_CB_PROORDERINFO t1 inner join T_CB_PROORDERDIME t2 on t1.FPRODUCTDIMEID=t2.FPRODUCTDIMEIDin 阅读全文
摘要:
ICTemplateEntry表 和 icclasstableinfo 表 阅读全文
摘要:
select substring(str,charindex('-',fnumber)+1,len(fnumber)-charindex('-',fnumber)),substring(fnumber,len(REVERSE(fnumber))-charindex('.',REVERSE(fnumb 阅读全文