摘要：https://www.cnblogs.com/accumulater/p/6807647.html https://blog.csdn.net/qq_40281800/article/details/78503181 阅读全文

摘要：1.navicat for mysql 数据库备份与还原https://www.cnblogs.com/helkbore/p/5741694.html2.实现数据库备份与还原[归纳三种方法]https://www.cnblogs.com/visec479/p/4103029.html 3.一个跨库复 阅读全文

摘要：select swr.id,swr.name,swr.sort as type,count(swl.id) as nums,ifnull(sum(swl.package_num),0) packageNum from sys_warehouse_roadway swr left join sys_w 阅读全文

摘要：批次导数据表头 SELECT [运单号] , [运单号] AS [订单号] , [运单号] AS [订单号] , [运单号] , SUM([price] * [ProductNum]) AS [订单总价] , SUM(CAST(( temp.[Weight] * ( CAST (temp.Produ 阅读全文

摘要：--包裹单号 入库时间 交易号 商品分类 商品名称 实付款SELECT a.DeliveryCode AS '包裹单号',a.DomesticWarehouseInTime AS '入库时间',a.TradeOrderID AS '交易号',(SELECT TOP 1 CatalogName FRO 阅读全文

摘要： 阅读全文

摘要：DECLARE @Data NVARCHAR(30);DECLARE @Data2 NVARCHAR(30);SET @Data = @DataDate;SET @Data = CONVERT(CHAR(30), DATEADD(HOUR, 8, @Data), 120);SET @Data2 = 阅读全文

摘要：例子：https://blog.csdn.net/wikey_zhang/article/details/76849826 DECLARE @limitDay INT;SET @limitDay = 35;IF DATEDIFF(DAY, '2018-03-21 00:00:00', '2018-0 阅读全文

摘要：SELECT B.TradeOrderID AS '二段交易号',B.ZipCode AS '邮编', B.Province AS '省',B.City AS '市',B.District AS '区',B.TransportOrderCode AS '运单号',B.ExceptionFlag, R 阅读全文

摘要：USE [Tr.TWX]GO /****** Object: StoredProcedure [dbo].[GetSysCode] Script Date: 2018/2/2 11:08:31 ******/SET ANSI_NULLS ONGO SET QUOTED_IDENTIFIER ONGO 阅读全文

摘要：SELECT a.TradeOrderID 二段交易号 , c.TradeOrderID 一段订单号 , a.BaggingDate AS 出库时间 , a.TransportOrderCode AS 转运单号 , a.TransportOrderCodeEx AS 外部单号 , a.Country 阅读全文

摘要：DECLARE @beginTime VARCHAR(20)= '2017-12-20 00:00:00';DECLARE @endTime VARCHAR(20)= '2017-12-26 00:00:00';DECLARE @country VARCHAR(20)= '';DECLARE @Or 阅读全文

摘要：DECLARE @beginTime DATETIME= '2017-12-20 00:00:00';DECLARE @endTime DATETIME= DATEADD(DAY, 1, @beginTime);SELECT CONVERT(VARCHAR(10), 日期, 23) 日期 , 线路 阅读全文

摘要：DECLARE @StartDate DATETIME= '2017-12-20 00:00:00';DECLARE @EndDate DATETIME= '2017-12-26 00:00:00';DECLARE @Country NVARCHAR(20)= '';DECLARE @到港单量 IN 阅读全文

摘要：DECLARE @date DATETIME = '2017-12-26 00:00:00';DECLARE @date2 DATETIME = DATEADD(DAY, 1, @date);DECLARE @1 TABLE ( subdate INT );DECLARE @result TABLE 阅读全文

摘要：DECLARE @limitDay INT;SET @limitDay = 92;IF DATEDIFF(DAY, '2017-12-13 00:00:00', '2017-12-13 18:00:00') > @limitDay BEGIN RETURN; END;SELECT Transport 阅读全文

摘要：DECLARE @i INTSET @i = 1WHILE @i > 0 BEGIN DECLARE @TransportFormMstID BIGINT; DECLARE @TradeOrderID BIGINT; DECLARE @TransportFormMstID_T BIGINT; DEC 阅读全文

摘要：DECLARE @StartDate DATETIME= '2017-10-13 00:00:00';DECLARE @EndDate DATETIME= '2017-11-13 23:00:00';DECLARE @Country NVARCHAR(20)= '中国香港';DECLARE @到港单 阅读全文

摘要：DECLARE @beginTime VARCHAR(20)= '2017-11-13 00:00:00';DECLARE @endTime VARCHAR(20)= '2017-11-13 23:00:00';DECLARE @country VARCHAR(20)= '中国香港';DECLARE 阅读全文

摘要：DECLARE @date DATETIME= '2016-11-01'; DECLARE @date2 DATETIME= DATEADD(day, 1, @date); Declare @1 Table( subdate INT) Declare @result Table( Stype VAR 阅读全文