... ICClassLink WHERE FDestClassTypeID = -1 AND FSourClassTypeID = 1007351[*]GO[*]--CRM_SampleReqEntry 样品申请单表体 改成交货通知单表体 ICDeliveryNoticeEntry[*]INSERT INTO ICClassLink(FSourClassTypeID,FDestClassTypeID,FSourBillShowIndex,FAllowCopy,FAllowCheck,FAllowForceCheck,FFlow...
时间:2017-03-03 14:42栏目:k3wise知识
...号的字段长度exec p_AlterColumn 't_ICItemCore','FModel','varchar(255)'GO--实际长度UPDATE t_ItemPropDesc SET FActualSize = 255 WHERE FItemClassID = 4 AND FSQLColumnName ='FModel'GO--精度,也是字符串的长度UPDATE t_ItemPropDesc SET FPrecision = 255 WHERE FItemClassID = 4 AND FSQLCol...
时间:2020-05-20 14:00栏目:k3wise知识
USE [tempdb] GO DBCC FREESYSTEMCACHE ('ALL') GO DBCC SHRINKFILE (N'tempdev' , 500) GO
时间:2022-12-30 16:12栏目:k3wise知识
...--查询采购发票信息SELECT * FROM ICPurchase where FBillNo='13726781'go--查询采购发票中相关核销数量、金额SELECT FCheckQty,--已核销数量FRemainQty,--剩余数量FRemainAmount,--本币未核销金额FCheckAmount,--本币核销金额FRemainAmountFor,--原币未核销金...
时间:2020-12-14 14:59栏目:k3wise知识
...异常后果自负! 第一步:找逻辑文件名use master go RESTORE FILELISTONLY FROM disk='C:\K3Data-bak\FF20230109.bak' Go // disk= 备份文件存放路径 第二步,恢复备份的帐套use master go Restore Database&nb...
时间:2023-07-07 13:29栏目:k3wise知识
...em a where fname=@oldnameexec update_name '26-F63949喷漆','26-F63949'goexec update_name'26-H46992喷漆','26-H46992'go根据以上代码,提出两个问题点:1、update_name '26-F63949喷漆','26-F63949' go --不用exce时,会报错;2、exec update_name '26-F63949喷漆','26-F63...
时间:2018-08-15 09:07栏目:k3wise知识
...户。举例 用户名:demo, 密码123, 数据库testUSE [master] GO CREATE LOGIN [demo] WITH PASSWORD=N'123', DEFAULT_DATABASE=[test], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE [test] GO CREATE USER [demo] FOR LOGIN [demo...
时间:2022-06-28 15:58栏目:云星空知识
...行处理。SELECT * FROM ICStockBill WHERE FBillNo ='销售出库单号'GOSELECT FRealPrice,FAuxPrice,FAmount,* FROM ICStockBillEntry WHERE FInterID=销售出库单ID号GO--更新销售出库单上的成本单价与成本金额UPDATE ICStockBillEntry SET FAuxPrice='单位成本',FAmount='成本金...
时间:2021-11-13 22:03栏目:k3wise知识
...UPDATE ICClassType SET FControl = (FControl | 8192)-8192 WHERE FID=1000050GO--增加8192即改为WEB单据UPDATE ICClassType SET FControl = FControl | 8192 WHERE FID=1000050GO【emoji】
时间:2020-04-30 09:53栏目:k3wise知识
...:USE 数据库EXEC sp_configure 'max text repl size', -1 ; GO RECONFIGURE; GO
时间:2023-02-02 22:58栏目:云星空知识