<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qingwenc的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qingwenc</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qingwenc]]></copyright><item><title><![CDATA[Sql Prompt10试用过期怎么重新激活]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/142568528</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/142568528</guid><author>qingwenc</author><pubDate>Thu, 26 Sep 2024 18:31:20 +0800</pubDate><description><![CDATA[我的sql prompt10激活后，过了14天试用过期了，请问怎样重新激活。]]></description><category></category></item><item><title><![CDATA[阿里云-docker安装rabbitmq及无法访问主页]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/122253464</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/122253464</guid><author>qingwenc</author><pubDate>Fri, 31 Dec 2021 11:55:07 +0800</pubDate><description><![CDATA[一、下载最新的rabbitmq
docker pull rabbitmq
二、下载完以后启动容器
docker run -d -p 5672:5672 -p 15672:15672 --name myrabbitmq 镜像id
三、 docker ps -a 查看正在运行的容器
四、进入阿里云的控制台 在安全组—》》添加15672和5672端口
五、输入http://ip地址：端口号 如： http://192.168.2.11:15672/
六、访问此rabbitmq主页时会出现无法访问，这是因为没有开启]]></description><category></category></item><item><title><![CDATA[C# Microsoft.Office.Interop.Excel分组汇总]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/120043064</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/120043064</guid><author>qingwenc</author><pubDate>Wed, 01 Sep 2021 16:33:15 +0800</pubDate><description><![CDATA[效果如下：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using TX.DataAccess;
using Microsoft.Office.Interop.Excel;



nam]]></description><category></category></item><item><title><![CDATA[sql server COUNT(1) OVER (PARTITION BY DBNo,GroupName )计算不同组合字段汇总]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/120042727</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/120042727</guid><author>qingwenc</author><pubDate>Wed, 01 Sep 2021 16:24:00 +0800</pubDate><description><![CDATA[可以根据group by字段，算出其中一个或多个组合的汇总
SELECT EmpID,,WorkDate
DBNo,GroupName AS ProdLine,COUNT(1)  OVER (PARTITION BY DBNo,GroupName,Workdate )  AS CNT, ---CNT表示该生产线每天有多少人参与计件
COUNT(1)   OVER (PARTITION BY DBNo,GroupName  )  AS CNTByProdLine from A GROUP BY  EmpID,]]></description><category></category></item><item><title><![CDATA[sql server 字符串列多行转换为一行拼接和转换为多行]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/119927015</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/119927015</guid><author>qingwenc</author><pubDate>Thu, 26 Aug 2021 11:07:39 +0800</pubDate><description><![CDATA[--STUFF：从位置1开始，截取1个字符串，替换为'',目的去除第一个逗号
--FOR XML PATH('')：行转列拼接字符串
STUFF((SELECT distinct ',' + aa.Customer FROM BC_OutQAReport aa  FOR XML PATH('')), 1, 1, '')  as Customer 


]]></description><category></category></item><item><title><![CDATA[sql server创建流水号 年月日+流水号]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/119869755</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/119869755</guid><author>qingwenc</author><pubDate>Mon, 23 Aug 2021 15:09:48 +0800</pubDate><description><![CDATA[Create function [dbo].[f_GetFxNum]()
returns varchar(15)
as
begin
declare @FxNum varchar(15)
declare @time varchar(8)
set @time=CONVERT(varchar,YEAR(GETDATE()))+RIGHT('00'+CONVERT(varchar,month(getdate())),2)+RIGHT('00'+CONVERT(varchar,DAY(getdate())),2)--]]></description><category></category></item><item><title><![CDATA[sql查看job的语句]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/119148688</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/119148688</guid><author>qingwenc</author><pubDate>Tue, 27 Jul 2021 17:14:32 +0800</pubDate><description><![CDATA[select * from msdb.dbo.sysjobs
select * from msdb.dbo.sysjobsteps

]]></description><category></category></item><item><title><![CDATA[centos7.6设置静态IP]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/118947085</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/118947085</guid><author>qingwenc</author><pubDate>Tue, 20 Jul 2021 23:49:34 +0800</pubDate><description><![CDATA[1.找到虚拟机的网关IP
路径：编辑–虚拟机网络编辑器–NAT设置


2.配置本地网络适配器 如VMnet8

3.配置虚拟机网络配置文件,可以用命令查看虚拟机用了哪个网络适配器

网络配置文件路径：cd /etc/sysconfig/network-scripts
vi ifcfg-ens33
TYPE="Ethernet"
PROXY_METHOD="none"
BROWSER_ONLY="no"
BOOTPROTO="static"#设置为静态static
DEFROUTE="yes"
IPV4_F]]></description><category></category></item><item><title><![CDATA[idea快捷键]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/118295885</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/118295885</guid><author>qingwenc</author><pubDate>Mon, 28 Jun 2021 10:30:31 +0800</pubDate><description><![CDATA[idea的debug调试快捷键

F9            resume programe 恢复程序

Alt+F10       show execution point 显示执行断点

F8            Step Over 相当于eclipse的f6      跳到下一步

F7            Step Into 相当于eclipse的f5就是  进入到代码

Alt+shift+F7  Force Step Into 这个是强制进入代码

Shift+F8      Step Ou]]></description><category></category></item><item><title><![CDATA[springboot单元测试]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/118162209</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/118162209</guid><author>qingwenc</author><pubDate>Wed, 23 Jun 2021 20:51:03 +0800</pubDate><description><![CDATA[1.添加依赖包
&lt;!-- Spring Boot Test 依赖 --&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
            &lt;artifactId&gt;spring-boot-starter-test&lt;/artifactId&gt;
&lt;!--            &lt;scope&gt;test&lt;/sco]]></description><category></category></item><item><title><![CDATA[注解进行代码测试]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/117848035</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/117848035</guid><author>qingwenc</author><pubDate>Sat, 12 Jun 2021 15:24:06 +0800</pubDate><description><![CDATA[1.创建注解类
package ceshi;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
@Retention(RetentionPolicy.RUNTIME)
public @interface Jiecha {
}

2.创建类并为方法添加注解
package ceshi;
import ceshi.Jiecha;
public class NoBug {
    @Jiecha
]]></description><category></category></item><item><title><![CDATA[C# 条件拼接]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/117476491</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/117476491</guid><author>qingwenc</author><pubDate>Wed, 02 Jun 2021 17:40:22 +0800</pubDate><description><![CDATA[StringBuilder sb = new StringBuilder();
            string SalesStatus = this.drpLineStatus.SelectedValue.ToString();
            string RemainSalesPhysical1 = this.drpDeliverRemainder.SelectedValue.ToString();
            string RemainSalesPhysical2 =...]]></description><category></category></item><item><title><![CDATA[sql分页查询语句]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/117475418</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/117475418</guid><author>qingwenc</author><pubDate>Wed, 02 Jun 2021 17:18:25 +0800</pubDate><description><![CDATA[1.调用的存储过程
Create PROCEDURE [db_datareader].[SP_Test]
@ActionType NVARCHAR(40) = NULL,
@SqlWhere nvarchar(2000)=null,
@PageSize int = NULL,
@PageIndex int = NULL,
@RecordCount bigint=null OUTPUT

AS
BEGIN
if(@ActionType='Process1')
	BEGIN
     	exec [spG_Te]]></description><category></category></item><item><title><![CDATA[递归树节点的使用]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/116398849</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/116398849</guid><author>qingwenc</author><pubDate>Tue, 04 May 2021 11:28:14 +0800</pubDate><description><![CDATA[using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using TX.DataAccess;
using TX.FrameWorks;
using LT.Production.DataAccess]]></description><category></category></item><item><title><![CDATA[keepalived命令]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/115418578</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/115418578</guid><author>qingwenc</author><pubDate>Sat, 03 Apr 2021 17:42:55 +0800</pubDate><description><![CDATA[1;systemctl daemon-reload  重新加载
2:systemctl enable keepalived.service  设置开机自动启动
3:systemctl disable keepalived.service 取消开机自动启动
4:systemctl start keepalived.service 启动
5:systemctl stop keepalived.service停止

]]></description><category></category></item><item><title><![CDATA[给传进来的sql变量添加单引号(‘‘)]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/115417976</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/115417976</guid><author>qingwenc</author><pubDate>Sat, 03 Apr 2021 16:55:07 +0800</pubDate><description><![CDATA[print QUOTENAME('A',char(39))--'A'
print QUOTENAME('A')--[A]


]]></description><category></category></item><item><title><![CDATA[拼接字符串转化为table并作为查询条件]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/115417823</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/115417823</guid><author>qingwenc</author><pubDate>Sat, 03 Apr 2021 16:48:41 +0800</pubDate><description><![CDATA[DECLARE @DATAAREAID AS NVARCHAR(MAX)
set @DATAAREAID='001,002,003,004'
if object_id('tempdb..##MyTempTable1') is not null
	Begin
		DROP TABLE ##MyTempTable1  --如果有存在就删除临时表
	End
	Select * Into ##MyTempTable1 From 
	(
		SELECT B.id,B.typeid  
		FROM   (  
		]]></description><category></category></item><item><title><![CDATA[pivot]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/115417783</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/115417783</guid><author>qingwenc</author><pubDate>Sat, 03 Apr 2021 16:45:08 +0800</pubDate><description><![CDATA[实现动态行转列
DECLARE @cols AS NVARCHAR(MAX), @query  AS NVARCHAR(MAX);
if object_id('tempdb..##tmp1') is not null
begin
        DROP TABLE ##tmp1 
end
if object_id('tempdb..##tmp2') is not null
begin       
         DROP TABLE ##tmp2
end
;
with tmpdata as 
(   ]]></description><category></category></item><item><title><![CDATA[Springboot项目启动Flowable工作流的问题]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/115024323</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/115024323</guid><author>qingwenc</author><pubDate>Sat, 20 Mar 2021 11:09:17 +0800</pubDate><description><![CDATA[项目启动出错，相关工作流的表会创建不完整
Error:Using a TIMESTAMP data type with a fractional precision of 6 is not supported on mariadb: A timestamp datatype with 6 fractional digits was requested, but MySQL only supports 0 digits.
因为MySQL版本不支持Timestamp(n)的写法，需更新MySQL版本。
在MyS]]></description><category></category></item><item><title><![CDATA[Nginx日志切割-手动]]></title><link>https://blog.youkuaiyun.com/qingwenc/article/details/114717200</link><guid>https://blog.youkuaiyun.com/qingwenc/article/details/114717200</guid><author>qingwenc</author><pubDate>Sat, 13 Mar 2021 01:41:40 +0800</pubDate><description><![CDATA[1.在sbin目录下创建可执行文件cut_my_log.sh,内容如下：
以分钟创建日志
#!/bin/bash
LOG_PATH="/usr/local/nginx/logs"
RECORD_TIME=$(date -d "yesterday" +%Y-%m-%d+%H:%M)
PID=${LOG_PATH}/nginx.pid
mv ${LOG_PATH}/access.log ${LOG_PATH}/access.${RECORD_TIME}.log
mv ${LOG_PATH}/error.log ]]></description><category></category></item></channel></rss>