摘要:
三星(SAMSUNG)905S3G-K07 安装Windows 7 过程分享http://www.cnblogs.com/scue/p/4100743.html打开方式没有excelhttp://jingyan.baidu.com/article/5552ef473fb1f7518ffbc98a.h... 阅读全文
摘要:
提取单元格中的数字部分=MID(LOOKUP(1,-(1&MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&1/17)),ROW($1:$15)))),3,15) 阅读全文
摘要:
select a.itemcode,b.itemname,b.spec,b.unit,b.rprice,sum(a.rqty) rqtyfrom tm_possale_detail a,sys_iteminfo bwhere a.itemcode=b.itemcode group by a.it... 阅读全文
摘要:
DELETE FROM YSDJDELETE FROM XDMXDELETE FROM DZMXDELETE FROM DZCYDELETE FROM FPMXDELETE FROM SKDMXDELETE FROM SKMXDELETE FROM JEMXDELETE FROM LSFPDELET... 阅读全文
摘要:
select a.pluno,a.pluname,a.spec,a.qty,d.qty,e.qty,a.dptno,substring(a.dptno,1,3),f.dptname,substring(a.dptno,1,4),g.dptname,substring(a.dptno,1,5),h.d... 阅读全文
摘要:
--抓取西部POS数据DELETE FROM POSLSBFINSERT INTO POSLSBFselect * from [192.168.1.100].[SCMIS].DBO.possrlbf WHERE SLDAT>'20130101'ORDER BY 1INSERT INTO POSXBB... 阅读全文
摘要:
update basplumain set dptid=1delete from basdept where id!=1insert into basdept (dptno,dptname)select dptno,dptname from lhflm update basdept set pid=... 阅读全文
摘要:
----SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOCreate Procedure vipinsert(@RETURN bit output)ASBEGIN BEGIN TRANSACTION insert into bas... 阅读全文
摘要:
SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOALTER procedure GetVIPMark(@SLDAT datetime, @PNO integer, @SNO integer, @VIPNO varchar(20), @PLUInfo... 阅读全文
摘要:
SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOALTER trigger POSUpdateValidVIP on POSSRLBF for update asbegin declare @SECTION varchar(80), @CODE ... 阅读全文