<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_37985261的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_37985261</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_37985261]]></copyright><item><title><![CDATA[删除所有表数据]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/88534309</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/88534309</guid><author>qq_37985261</author><pubDate>Wed, 13 Mar 2019 15:49:48 +0800</pubDate><description><![CDATA[DECLARE @strSQL NVARCHAR(MAX)
SET @strSQL=''

SELECT @strSQL=@strSQL+' drop table ['+name +'];'
from sysobjects
WHERE [type]='U'

and (name like 'edi_%')
and name not in('EdiFinancialInterface','Ed...]]></description><category></category></item><item><title><![CDATA[地图坐标系互转]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/82589822</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/82589822</guid><author>qq_37985261</author><pubDate>Mon, 10 Sep 2018 15:01:31 +0800</pubDate><description><![CDATA[
public class GpsUtil
{
    public static double pi = 3.1415926535897932384626;
    public static double x_pi = 3.14159265358979324 * 3000.0 / 180.0;
    public static double a = 6378245.0;
    public...]]></description><category></category></item><item><title><![CDATA[SQL语句]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/81051001</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/81051001</guid><author>qq_37985261</author><pubDate>Sun, 15 Jul 2018 10:50:06 +0800</pubDate><description><![CDATA[USE [FRD]
GO
/****** Object:  StoredProcedure [dbo].[PayMoneySearch]    Script Date: 07/15/2018 10:49:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER proc [dbo].[PayMoneySearch]
(@s...]]></description><category></category></item><item><title><![CDATA[返回值out sql]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80831123</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80831123</guid><author>qq_37985261</author><pubDate>Wed, 27 Jun 2018 16:23:34 +0800</pubDate><description><![CDATA[USE [YunNanHw]
GO
/****** Object:  StoredProcedure [dbo].[AbnormalityLocation]    Script Date: 06/27/2018 16:23:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =========================...]]></description><category></category></item><item><title><![CDATA[sql 根据字段拆分 查询in 语句]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80831101</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80831101</guid><author>qq_37985261</author><pubDate>Wed, 27 Jun 2018 16:23:00 +0800</pubDate><description><![CDATA[USE [YunNanHw]
GO
/****** Object:  StoredProcedure [dbo].[AbnormalityLocationNew]    Script Date: 06/27/2018 16:20:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ======================...]]></description><category></category></item><item><title><![CDATA[存储过程带有参数返回值和游标的]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80603824</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80603824</guid><author>qq_37985261</author><pubDate>Thu, 07 Jun 2018 08:49:07 +0800</pubDate><description><![CDATA[USE [YunNanHw]
GO
/****** Object:  StoredProcedure [dbo].[EventReport]    Script Date: 06/07/2018 08:47:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 ALTER proc [dbo].[EventReport]
  (
...]]></description><category></category></item><item><title><![CDATA[存储过程分页]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80603800</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80603800</guid><author>qq_37985261</author><pubDate>Thu, 07 Jun 2018 08:45:50 +0800</pubDate><description><![CDATA[USE [FRD]
GO
/****** Object:  StoredProcedure [dbo].[ProdunctCount]    Script Date: 06/07/2018 08:43:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[ProdunctCount]
(

@cu...]]></description><category></category></item><item><title><![CDATA[Subsonic 执行存储过程]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80590070</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80590070</guid><author>qq_37985261</author><pubDate>Wed, 06 Jun 2018 09:19:43 +0800</pubDate><description><![CDATA[  StoredProcedure spd = new StoredProcedure(&quot;PayMoneySearch&quot;);
            spd.Command.AddParameter(&quot;@starttime&quot;, c.GetQueryStr(qList, &quot;PudDate&quot;));
            spd.Command.AddParameter(&quot;@endtime&quot;, c.G...]]></description><category></category></item><item><title><![CDATA[mvc 视图 js 循环取list数据]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80535467</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80535467</guid><author>qq_37985261</author><pubDate>Fri, 01 Jun 2018 11:28:40 +0800</pubDate><description><![CDATA[var list =@Html.Raw(JsonConvert.SerializeObject(ViewBag.list));
        for (var qwe = 0; qwe &amp;lt; '@ViewBag.list.Count'; qwe++) {@using Newtonsoft.Json;]]></description><category></category></item><item><title><![CDATA[js经常用到的方法]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80480437</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80480437</guid><author>qq_37985261</author><pubDate>Mon, 28 May 2018 11:59:17 +0800</pubDate><description><![CDATA[1，判断js一个值是否为空if(value == '' || value == undefined || value == null)
{
    alert(&quot;为空&quot;);
    return false;
}]]></description><category></category></item><item><title><![CDATA[List去重、遍历循环类属性和值、数组比较、集合根据属性倒叙]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80434715</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80434715</guid><author>qq_37985261</author><pubDate>Thu, 24 May 2018 15:06:40 +0800</pubDate><description><![CDATA[/// &amp;lt;summary&amp;gt;
        /// 获取员工全年考核记录  朱常玮 2018年5月23日
        /// &amp;lt;/summary&amp;gt;
        /// &amp;lt;param name=&quot;queryStr&quot;&amp;gt;&amp;lt;/param&amp;gt;
        /// &amp;lt;returns&amp;gt;&amp;lt;/returns&amp;gt;
        [H]]></description><category></category></item><item><title><![CDATA[case when then 语句]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80432990</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80432990</guid><author>qq_37985261</author><pubDate>Thu, 24 May 2018 13:05:43 +0800</pubDate><description><![CDATA[SELECT Id, TypeName, ParentId, DepartId, CusId, ImageUrl, Ext1, Ext2, Ext3,(SELECT     COUNT(*)FROM  dbo.VPartInfo WHERE( case when a.ParentId = '0' then VPartInfo.BigType else VPartInfo.SmallType END...]]></description><category></category></item><item><title><![CDATA[高效分页]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80423389</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80423389</guid><author>qq_37985261</author><pubDate>Wed, 23 May 2018 17:36:55 +0800</pubDate><description><![CDATA[SELECT  TOP 15 * FROM (SELECT ROW_NUMBER () OVER (ORDER BY VDepartAdminPower.ID DESC) AS rownumber,VDepartAdminPower.*FROM 
VDepartAdminPower
 WHERE  (  [DepartRelationId] like '%201608031119253248-95...]]></description><category></category></item><item><title><![CDATA[需求：根据部门分组，显示每个部门的工资等级(百度经验)]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80422880</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80422880</guid><author>qq_37985261</author><pubDate>Wed, 23 May 2018 17:11:55 +0800</pubDate><description><![CDATA[实例：初始化数据create table employee (empid int ,deptid int ,salary decimal(10,2))insert into employee values(1,10,5500.00)insert into employee values(2,10,4500.00)insert into employee values(3,20,1900.00)in...]]></description><category></category></item><item><title><![CDATA[统计年龄段的人数（存储过程）]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80422416</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80422416</guid><author>qq_37985261</author><pubDate>Wed, 23 May 2018 16:49:11 +0800</pubDate><description><![CDATA[USE [YunNanHuanWei]
GO
/****** Object:  StoredProcedure [dbo].[UserAge]    Script Date: 05/23/2018 13:24:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[UserAge]
(
--多个年龄...]]></description><category></category></item><item><title><![CDATA[气体仪器(服务)]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80416929</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80416929</guid><author>qq_37985261</author><pubDate>Wed, 23 May 2018 10:57:35 +0800</pubDate><description><![CDATA[using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Diagnostics;
using System.IO;
using System.Linq;
using System.N...]]></description><category></category></item><item><title><![CDATA[气体仪器WinForm代码（服务器端）]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80416842</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80416842</guid><author>qq_37985261</author><pubDate>Wed, 23 May 2018 10:55:06 +0800</pubDate><description><![CDATA[using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Net;
using System.Net.Sockets;
using System.Text;
...]]></description><category></category></item><item><title><![CDATA[crc16验证（硬件使用）]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80416685</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80416685</guid><author>qq_37985261</author><pubDate>Wed, 23 May 2018 10:50:58 +0800</pubDate><description><![CDATA[using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SocketServer
{
    public class CRC16
    {
        /// &amp;lt;summary&amp;gt;
 ...]]></description><category></category></item><item><title><![CDATA[subsonic 权限代码 拼Like语句]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80416217</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80416217</guid><author>qq_37985261</author><pubDate>Wed, 23 May 2018 10:36:45 +0800</pubDate><description><![CDATA[public static SqlQuery PhoneDataPowerFilter(SqlQuery sq, string Admin)
        {
            if (LoginInfo.RoleID != &quot;1&quot;)
            {
                Sys_Admin admin = new Sys_Admin(Admin);
        ...]]></description><category></category></item><item><title><![CDATA[通用方法整合]]></title><link>https://blog.youkuaiyun.com/qq_37985261/article/details/80416184</link><guid>https://blog.youkuaiyun.com/qq_37985261/article/details/80416184</guid><author>qq_37985261</author><pubDate>Wed, 23 May 2018 10:35:52 +0800</pubDate><description><![CDATA[using cn.jpush.api.common;
using cn.jpush.api.push.mode;
using cn.jpush.api.push.notification;
using cn.jpush.api.common.resp;
using System;
using System.Collections.Generic;
using System.Configuratio...]]></description><category></category></item></channel></rss>