<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[a923381014的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/a923381014</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; a923381014]]></copyright><item><title><![CDATA[ChineseLunisolarCalendar 农历日期]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324263</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324263</guid><author>a923381014</author><pubDate>Mon, 07 Jan 2019 14:31:00 +0800</pubDate><description><![CDATA[#region 农历日期
         
         

         static ChineseLunisolarCalendar cCalendar = new ChineseLunisolarCalendar();


         /// &lt;summary&gt;
         /// 返回生肖
       ...]]></description><category></category></item><item><title><![CDATA[sql server中case when的用法]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324265</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324265</guid><author>a923381014</author><pubDate>Fri, 30 Nov 2018 15:45:00 +0800</pubDate><description><![CDATA[Case具有两种格式。简单Case函数和Case搜索函数。



--简单Case函数
CASEsex
WHEN'1'THEN'男'
WHEN'2'THEN'女'
ELSE'其他'END
--Case搜索函数
CASEWHENsex='1'THEN'男'
WHENsex=...]]></description><category></category></item><item><title><![CDATA[Memcached Cache]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324261</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324261</guid><author>a923381014</author><pubDate>Fri, 16 Nov 2018 20:57:00 +0800</pubDate><description><![CDATA[using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Memcached.ClientLibrary;
using System.Collections;

namespace WL.Web.Common
{
    public clas...]]></description><category></category></item><item><title><![CDATA[查询表、字段、类型、是否主键、长度、小数位、是否允许空、默认值等详细查询...]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324262</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324262</guid><author>a923381014</author><pubDate>Wed, 10 Oct 2018 23:03:00 +0800</pubDate><description><![CDATA[效果



SELECT   
 (case when a.colorder=1 then d.name else '' end) as 表名,--如果表名相同就返回空  
     a.colorder as 字段序号,  
     a.name as 字段名,  
     (case when COLUMNPROPERTY( a.id,a.name,'IsIde...]]></description><category></category></item><item><title><![CDATA[标准北京时间同步]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324260</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324260</guid><author>a923381014</author><pubDate>Wed, 19 Sep 2018 13:57:00 +0800</pubDate><description><![CDATA[淘宝：http://api.m.taobao.com/rest/api3.do?api=mtop.common.getTimestamp苏宁：http://quan.suning.com/getSysTime.doQQ： http://cgi.im.qq.com/cgi-bin/cgi_svrtime北京时间网：https://bjtime.cn/st.asp


c# 获取和...]]></description><category></category></item><item><title><![CDATA[删除表中重复id值]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324259</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324259</guid><author>a923381014</author><pubDate>Tue, 19 Jun 2018 03:07:00 +0800</pubDate><description><![CDATA[DELETEtFROM(SELECT*,ROW_NUMBER()OVER(PARTITIONBYtest1,test2,test3,test4ORDERBYRAND())ASRNFROMTableName)AStWHERERN&gt;1

转载于:https://www.cnblogs.com/ainidewen/p/9196929.html...]]></description><category></category></item><item><title><![CDATA[使用canvas压缩图片 并上传]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324257</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324257</guid><author>a923381014</author><pubDate>Thu, 12 Apr 2018 11:00:00 +0800</pubDate><description><![CDATA[&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
    &lt;meta charset="UTF-8"&gt;
    &lt;title&gt;上传文件&lt;/title&gt;
    &lt;script src="http://libs.baidu.com/jquery/1.8.3/jquery.min.js"&g...]]></description><category></category></item><item><title><![CDATA[使用LogParser 将iis日志导入到数据库中]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324244</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324244</guid><author>a923381014</author><pubDate>Fri, 02 Mar 2018 11:22:00 +0800</pubDate><description><![CDATA[--注意修改日志位置和表名--u_ex180228.log  日志所在位置
--IISLog 表名--IISLog_table_0228 表名"C:\Program Files (x86)\Log Parser 2.2\LogParser.exe" "SELECT * FROM D:\LogFiles\W3SVC1\u_ex180228.log  TO IISLog_table_022...]]></description><category></category></item><item><title><![CDATA[查询表大小和行数]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324242</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324242</guid><author>a923381014</author><pubDate>Sat, 24 Feb 2018 10:42:00 +0800</pubDate><description><![CDATA[select object_name(id) tablename   ,8*reserved/1024 reserved1 ,rtrim(8*dpages/1024)+'Mb' used,8*(reserved-dpages)/1024 unused,8*dpages/1024-rows/1024*minlen/1024 free,
rows from sysindexes 
w...]]></description><category></category></item><item><title><![CDATA[sqlserver快速删除整个表数据]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324241</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324241</guid><author>a923381014</author><pubDate>Sat, 24 Feb 2018 10:36:00 +0800</pubDate><description><![CDATA[--删除整个表数据

SET STATISTICS TIME ON;
DECLARE @Timer DATETIME = GETDATE();

TRUNCATE TABLE LOG_DEBUG_ERROR ; 

SELECT DATEDIFF(MS, @Timer, GETDATE()) AS [执行时间(毫秒)];
SET STATISTICS TIME OFF...]]></description><category></category></item><item><title><![CDATA[mssql 递归]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324256</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324256</guid><author>a923381014</author><pubDate>Sat, 27 May 2017 11:24:00 +0800</pubDate><description><![CDATA[--递归id往下所有内容with temp ( URE_ID, URE_PARENT_ID,URE_NAME ,URE_TYPE)as(select URE_ID, URE_PARENT_ID,URE_NAME ,URE_TYPEfrom ASM_USER_REGIONwhere URE_PARENT_ID= 23union allselect a.URE_ID, a.URE_PAREN...]]></description><category></category></item><item><title><![CDATA[显示表中重复数据,并显示重复条数]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324255</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324255</guid><author>a923381014</author><pubDate>Fri, 14 Apr 2017 10:23:00 +0800</pubDate><description><![CDATA[SELECT EXU_DEPARTMENT,count(EXU_DEPARTMENT) as count 
FROM EXA_USER 
GROUP BY EXU_DEPARTMENT HAVING count(EXU_DEPARTMENT) &gt;1 
ORDER BY count DESC;


　　

转载于:https://www.cnblogs.com/ain...]]></description><category></category></item><item><title><![CDATA[ASP.NET摄像头拍照  640*480   450*550]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324254</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324254</guid><author>a923381014</author><pubDate>Wed, 29 Mar 2017 09:47:00 +0800</pubDate><description><![CDATA[下载地址

转载于:https://www.cnblogs.com/ainidewen/p/6638156.html]]></description><category></category></item><item><title><![CDATA[使用 jquery.webcam 进行asp.net 拍照]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324252</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324252</guid><author>a923381014</author><pubDate>Sat, 25 Mar 2017 14:29:00 +0800</pubDate><description><![CDATA[HTML 代码

&lt;%@ Page Language="C#" AutoEventWireup="true" CodeBehind="index.aspx.cs" Inherits="JqueryCamera.index" %&gt;

&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "h...]]></description><category></category></item><item><title><![CDATA[修改服务器3389端口]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324251</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324251</guid><author>a923381014</author><pubDate>Fri, 20 Jan 2017 10:14:00 +0800</pubDate><description><![CDATA[修改服务器端的端口设置 ，注册表有2个地方需要修改。
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\Wds\rdpwd\Tds\tcp] PortNumber值，默认是3389，修改成所希望的端口，如6222。[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSe...]]></description><category></category></item><item><title><![CDATA[android  自动更新]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324248</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324248</guid><author>a923381014</author><pubDate>Wed, 18 Jan 2017 09:52:00 +0800</pubDate><description><![CDATA[package com.wlwl.yiyuan;



import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.net.HttpURLConnection;
import java...]]></description><category></category></item><item><title><![CDATA[Android  全局错误管理]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324246</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324246</guid><author>a923381014</author><pubDate>Wed, 18 Jan 2017 09:51:00 +0800</pubDate><description><![CDATA[package com.wlwl.yiyuan;

import java.io.File;
import java.io.PrintWriter;
import java.io.StringWriter;
import java.io.Writer;
import java.lang.Thread.UncaughtExceptionHandler;
import ja...]]></description><category></category></item><item><title><![CDATA[adnroid  启动是没有标题栏]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324250</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324250</guid><author>a923381014</author><pubDate>Wed, 18 Jan 2017 09:48:00 +0800</pubDate><description><![CDATA[&lt;activity
            android:name=".MainActivity"
            android:theme="@android:style/Theme.Light.NoTitleBar.Fullscreen"
            android:label="@string/app_name"
            a...]]></description><category></category></item><item><title><![CDATA[控制弹出div显示在鼠标附近的位置]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324249</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324249</guid><author>a923381014</author><pubDate>Mon, 26 Sep 2016 13:13:00 +0800</pubDate><description><![CDATA[前一个页面:

 $("#txt_ocname").click(function () {
            art.dialog.open("/SelPosAll.aspx", { width: 650, height: 350, title: "请选择职位", lock: false,
                close: function () {
  ...]]></description><category></category></item><item><title><![CDATA[关于Visual Studio中的TraceDebugging文件夹]]></title><link>https://blog.youkuaiyun.com/a923381014/article/details/101324247</link><guid>https://blog.youkuaiyun.com/a923381014/article/details/101324247</guid><author>a923381014</author><pubDate>Wed, 26 Aug 2015 09:04:00 +0800</pubDate><description><![CDATA[最近一段时间发现C盘莫名其妙的变小了，各种清理各种卸载还是没用，电脑慢的是在无法使用


。最后只能一个文件夹一个文件夹的找，最后针对“C:\Documents and Settings\All Users\Application Data\Microsoft Visual Studio\10.0\TraceDebugging”文件夹，发现这个文件夹有10GB大小。，然后查找了...]]></description><category></category></item></channel></rss>