<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[E_say_de]]></title><description><![CDATA[除了进步，没有什么可以做的]]></description><link>https://blog.youkuaiyun.com/lin304510260</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lin304510260]]></copyright><item><title><![CDATA[SqlServer 圆角半角符号查询问题]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/122825134</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/122825134</guid><author>lin304510260</author><pubDate>Tue, 08 Feb 2022 15:36:26 +0800</pubDate><description><![CDATA[SqlServer 圆角半角符号查询问题]]></description><category></category></item><item><title><![CDATA[Nuget根据packages.config文件，重新安装程序组件]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/120908374</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/120908374</guid><author>lin304510260</author><pubDate>Fri, 22 Oct 2021 16:22:32 +0800</pubDate><description><![CDATA[在“程序包管理器控制台”下执行以下语句

Update-Package -ProjectName '项目名称' -Reinstall
该语句作用：按照packages.config中给出的程序组件，重新下载安装一遍。
]]></description><category></category></item><item><title><![CDATA[Jenkins部署springboot+vue项目记录]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/120281139</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/120281139</guid><author>lin304510260</author><pubDate>Tue, 14 Sep 2021 10:29:27 +0800</pubDate><description><![CDATA[Jenkins部署springboot+vue项目记录
]]></description><category></category></item><item><title><![CDATA[docker简单入门经验(docker desktop、springboot、vue)]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/119454227</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/119454227</guid><author>lin304510260</author><pubDate>Fri, 06 Aug 2021 14:34:52 +0800</pubDate><description><![CDATA[docker简单入门经验
一.软件安装


docker-desktop(可以理解成docker的windows操作系统下的桌面程序)官方下载地址
https://docs.docker.com/docker-for-windows/install



docker-desktop安装，运行后，一直下一步可以了


插件wsl2下载安装
因为docker运行环境是Linux的，windows操作系统下要运行，就需要安装wsl2(Windows Subsystem for Linux 2),2是第二个版本的]]></description><category></category></item><item><title><![CDATA[oracle 实现ID自增]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/84885795</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/84885795</guid><author>lin304510260</author><pubDate>Fri, 07 Dec 2018 19:05:55 +0800</pubDate><description><![CDATA[--创建自增ID，名称为：表名_字段名_SEQ
CREATE SEQUENCE T_BASE_BRIDGE_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE;
 
 
-- 为Insert操作创建触发器，无需在SQL语句里写NEXTVAL，名称为表名_INS_TRG
CREATE OR REPLACE TRIGGER ...]]></description><category></category></item><item><title><![CDATA[执行最慢的SQL语句、总耗CPU最多的前个SQL、平均耗CPU最多的前个SQL]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/82951259</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/82951259</guid><author>lin304510260</author><pubDate>Sat, 06 Oct 2018 15:16:52 +0800</pubDate><description><![CDATA[--执行最慢的SQL语句
SELECT
(total_elapsed_time / execution_count)/1000 N'平均时间ms'
,total_elapsed_time/1000 N'总花费时间ms'
,total_worker_time/1000 N'所用的CPU总时间ms'
,total_physical_reads N'物理读取总次数'
,total_logical_rea...]]></description><category></category></item><item><title><![CDATA[多行数据转换成一个字符串]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/54378436</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/54378436</guid><author>lin304510260</author><pubDate>Thu, 12 Jan 2017 15:27:49 +0800</pubDate><description><![CDATA[select STUFF(
                    (select ','+UserID
                    FROM T_WorkFlow_MultiFlowInfo  a
                    WHERE b.FlowID =a.FlowID 
                    and a.isWork=0 and a.Flo]]></description><category></category></item><item><title><![CDATA[Oracle 根据字符串中某个字排序]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/53198043</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/53198043</guid><author>lin304510260</author><pubDate>Thu, 17 Nov 2016 11:43:35 +0800</pubDate><description><![CDATA[用正则匹配出需要排序的字，再用instr函数，得到索引。根据索引排序。
文件字排序，先排含有函的字，再到含有字的字。



 SELECT distinct XianShiN FROM TDICTSELECT where leibien='FileMaxNumber' order by instr('函,字',regexp_substr(XianShiN,'[函字]',1),1,1)]]></description><category></category></item><item><title><![CDATA[获取CheckBoxList选中项的Text值]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/53168460</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/53168460</guid><author>lin304510260</author><pubDate>Tue, 15 Nov 2016 10:02:25 +0800</pubDate><description><![CDATA[function getSelectedUser() {


                var strReturn = "";


            var CheckBoxList = document.getElementById("");
            if (CheckBoxList.tagName == "TABLE") {
            ]]></description><category></category></item><item><title><![CDATA[TextBox TextMode="Password" 不能赋值,页面回滚时数据会丢失的解决方法]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/52604118</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/52604118</guid><author>lin304510260</author><pubDate>Wed, 21 Sep 2016 08:55:35 +0800</pubDate><description><![CDATA[tbUserPwd.Attributes.Add("value", tbUserPwd.Text);
tbConfirmPwd.Attributes.Add("value", tbConfirmPwd.Text);]]></description><category></category></item><item><title><![CDATA[UpdatePanel无刷新问题。]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/52414727</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/52414727</guid><author>lin304510260</author><pubDate>Fri, 02 Sep 2016 16:07:56 +0800</pubDate><description><![CDATA[1。如：

            
            
        

如果选项中有Selected="True" 标记项，那么再次选回该项时，触发将会不生效。如果只有两项，那么相当于触发“是”选项后，将无法再触发刷新事件了。
如果有三个选项的话，只能靠非“否”选项去触发刷新事件。]]></description><category></category></item><item><title><![CDATA[JS文件使用项目文件的时候，使用的定位最好是使用调用这个JS文件的页面文件的定位。]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/51859765</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/51859765</guid><author>lin304510260</author><pubDate>Fri, 08 Jul 2016 11:52:31 +0800</pubDate><description><![CDATA[如test.js文件当中有引用文件aa.swf.
bb.aspx页面调用test.js文件。那么在定位这个SWF文件的时候，最好要使用bb.aspx页面的定位。]]></description><category></category></item><item><title><![CDATA[利用spt_values求2个时间段内所有的日期。主要用于关联数据。]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/51546441</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/51546441</guid><author>lin304510260</author><pubDate>Tue, 31 May 2016 15:55:05 +0800</pubDate><description><![CDATA[select convert(varchar(10),dateadd(day,number,'2016-05-01'),120)  as DTime
from master..spt_values 
where datediff(day,dateadd(day,number,'2016-05-01'), '2016-05-31')>=0
and number>=0 
and type='p]]></description><category></category></item><item><title><![CDATA[js获取url传递参数]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/50836610</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/50836610</guid><author>lin304510260</author><pubDate>Wed, 09 Mar 2016 16:45:55 +0800</pubDate><description><![CDATA[正则分析法。
function GetQueryString(name) {
   var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)","i");
   var r = window.location.search.substr(1).match(reg);
   if (r!=null) return (r[2]); return ]]></description><category></category></item><item><title><![CDATA[SQL删除所有重复数据。]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/47395603</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/47395603</guid><author>lin304510260</author><pubDate>Mon, 10 Aug 2015 10:58:31 +0800</pubDate><description><![CDATA[初始化数据：
IF object_id('tempdb..#a') IS NOT NULL
                        BEGIN
                            DROP TABLE #a
                        END  
   Select '11' as A,'22' as B,'33' as C into  #]]></description><category></category></item><item><title><![CDATA[ajaxpro组件提示页面类未定义处理]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/45099715</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/45099715</guid><author>lin304510260</author><pubDate>Fri, 17 Apr 2015 17:31:02 +0800</pubDate><description><![CDATA[在web.config文件中添加




和

        在 Internet 信息服务 7.0 下运行 ASP.NET AJAX 需要 system.webServer
        节。对早期版本的 IIS 来说则不需要此节。
    -->









如果添加完这两项后还报JS错误，那么就是IIS应用池的版本问题了。如果是.net2.0的]]></description><category></category></item><item><title><![CDATA[ajax同步处理的理解。]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/42970403</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/42970403</guid><author>lin304510260</author><pubDate>Wed, 21 Jan 2015 16:59:54 +0800</pubDate><description><![CDATA[ajax在没有设置异步属性“async”的情况下，默认该值是为true的。
如果将该属性设置为false后，js执行将会同步执行。
但有个奇怪的情况，如：

                    OnClick="btnJZB_Click" OnClientClick="return CheckForm();" />

unction CheckForm() {
         ]]></description><category></category></item><item><title><![CDATA[将查询到的结果拼接成字符串输出]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/41747851</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/41747851</guid><author>lin304510260</author><pubDate>Fri, 05 Dec 2014 15:02:28 +0800</pubDate><description><![CDATA[SELECT  AppID,
    (
    SELECT
      ',' + UserID
    FROM
      [T_sys_UserInfo] t1
    WHERE
      AppID = [T_sys_UserInfo].AppID
    FOR XML PATH('')
    ) AS UserID,
    (
    SELECT]]></description><category></category></item><item><title><![CDATA[后台直接给DropDownList添加onchange事件，达到无刷新效果。]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/40977331</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/40977331</guid><author>lin304510260</author><pubDate>Mon, 10 Nov 2014 10:31:56 +0800</pubDate><description><![CDATA[conReasonNo.Attributes.Add("onchange", string.Format("{0}.value={1}.value.replace('----','').replace('----','')+'：\\r\\n                 特此告知。\\r\\n                签章：\\r\\n                {2}' ", tbT]]></description><category></category></item><item><title><![CDATA[后台根据文本定位DropDownList选中值]]></title><link>https://blog.youkuaiyun.com/lin304510260/article/details/40977187</link><guid>https://blog.youkuaiyun.com/lin304510260/article/details/40977187</guid><author>lin304510260</author><pubDate>Mon, 10 Nov 2014 10:26:03 +0800</pubDate><description><![CDATA[ddlAppID.ClearSelection();
        string strUnitName = BLL.PublicInfo.Instance().GetFieldValue("T_Sys_UnitInfo", "UnitName", " UnitName like '%"+tbKeys.Text.Trim()+"%' ");
        ListItem item = d]]></description><category></category></item></channel></rss>