<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[三层楼的木房子]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/mine3333</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; mine3333]]></copyright><item><title><![CDATA[排名函数(ROW_NUMBER、RANK、DENSE_RANK)及OVER子句]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/50206537</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/50206537</guid><author>mine3333</author><pubDate>Mon, 07 Dec 2015 15:48:19 +0800</pubDate><description><![CDATA[--在部门内新水排名（如果有相同名次，用dense_rank)
SELECT row_number() over
(PARTITION BY t.deptno  --按部门分组
ORDER BY t.sal) rn, --部门内按薪水排序
 t.sal, t.ename, t.deptno 
  FROM emp t;
--分组累计计数，注意相同sal情况
SELECT COUNT(]]></description><category></category></item><item><title><![CDATA[The page is performing an async postback but the ScriptManager]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/50017253</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/50017253</guid><author>mine3333</author><pubDate>Tue, 24 Nov 2015 19:15:58 +0800</pubDate><description><![CDATA[在web.config 中加不加的时候默认是64]]></description><category></category></item><item><title><![CDATA[System.Web.UI.ViewStateException: Invalid viewstate 解决方法]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/50017061</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/50017061</guid><author>mine3333</author><pubDate>Tue, 24 Nov 2015 19:03:39 +0800</pubDate><description><![CDATA[应该是集群访问时出现的问题 需要配置machinekey
如果出现存放和解析不在同一台服务器时可能会出现问题]]></description><category></category></item><item><title><![CDATA[SQL  行内拼凑字符串 小记]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/45365807</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/45365807</guid><author>mine3333</author><pubDate>Wed, 29 Apr 2015 14:04:42 +0800</pubDate><description><![CDATA[SELECT TOP ( @PageSize )
                    ISNULL(c.CName + '('
                           + ( STUFF(( SELECT   ',' + LTRIM(RTRIM(TureName))
                                       FROM     dbo.Us]]></description><category></category></item><item><title><![CDATA[sql  having  小记]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/45042243</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/45042243</guid><author>mine3333</author><pubDate>Tue, 14 Apr 2015 14:57:10 +0800</pubDate><description><![CDATA[容易忘记的having 




SELECT FAge,COUNT(*) AS CountOfThisAge FROM T_Employee
GROUP BY FAge
WHERE COUNT(*)>1
可以在数据库系统中执行下面的SQL的时候，数据库系统会提示语法错误，这是因为聚合函
数不能在WHERE语句中使用，必须使用HAVING子句来代替，比如：
SELECT FAg]]></description><category></category></item><item><title><![CDATA[Linq 应用]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/41961351</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/41961351</guid><author>mine3333</author><pubDate>Tue, 16 Dec 2014 16:17:22 +0800</pubDate><description><![CDATA[1.Linq  Group



string[] arr={"www.baidu.com","www.aa.cn","www.bb.com","www.cbc.net","www.abc.com.cn","aaa"};
var arrs=from item in arr where item.LastIndexOf(".")!=-1 group by  item.SubString(i]]></description><category></category></item><item><title><![CDATA[Windows Server AppFabric在工作组(Workgroup)环境下的配置]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/41478501</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/41478501</guid><author>mine3333</author><pubDate>Tue, 25 Nov 2014 10:57:21 +0800</pubDate><description><![CDATA[http://www.entlib.net/?p=383]]></description><category></category></item><item><title><![CDATA[jquery 小记]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/38707295</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/38707295</guid><author>mine3333</author><pubDate>Wed, 20 Aug 2014 16:39:13 +0800</pubDate><description><![CDATA[$("p>span")
$("p~span")
$("p+span")]]></description><category></category></item><item><title><![CDATA[游标多行只执行一次]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/8463722</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/8463722</guid><author>mine3333</author><pubDate>Wed, 20 Aug 2014 15:54:45 +0800</pubDate><description><![CDATA[使用游标进行数据更新时
 CREATE TABLE #tab
            (
              CategoryID BIGINT ,
              StartTime DATETIME ,
              EndTime DATETIME
            )
        INSERT  #tab]]></description><category></category></item><item><title><![CDATA[sql  拼接查询 小记]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/28415959</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/28415959</guid><author>mine3333</author><pubDate>Wed, 04 Jun 2014 13:20:41 +0800</pubDate><description><![CDATA[SELECT  STUFF(( SELECT  ',' + LTRIM(RTRIM(TureName))
                FROM    dbo.RH_User
                WHERE   id IN ( 1, 2, 3 )
              FOR
                XML PATH('')
              ), ]]></description><category></category></item><item><title><![CDATA[WCF 新加表超时小记]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/17122163</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/17122163</guid><author>mine3333</author><pubDate>Wed, 04 Dec 2013 17:27:19 +0800</pubDate><description><![CDATA[将生成的文件放入项目后
1. 修改项目proxy 项目中的文件地址
2. 在服务端web.config 文件中配置services 节点
3. 重新在proxy 中添加服务引用并且勾选高级中的异步操作。]]></description><category></category></item><item><title><![CDATA[sql 获取字符串中最小的数]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/13507085</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/13507085</guid><author>mine3333</author><pubDate>Tue, 29 Oct 2013 13:59:58 +0800</pubDate><description><![CDATA[Create FUNCTION [dbo].[F_GetNumInStr] ( @s NVARCHAR(MAX) )
RETURNS MONEY
AS 
    BEGIN 


        DECLARE @s1 NVARCHAR(200)
        SET @s1 = @s
        DECLARE @strlen INT
        SET @strle]]></description><category></category></item><item><title><![CDATA[tsql XML 拆分]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/12561159</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/12561159</guid><author>mine3333</author><pubDate>Thu, 10 Oct 2013 11:11:43 +0800</pubDate><description><![CDATA[CREATE TABLE #tab1
    (
      id INT ,
      aa NVARCHAR(200) ,
      bb NVARCHAR(300)
    )
                
 
    
   
 INSERT INTO #tab1
        ( id, aa, bb )
 VALUES ( 1, N'aa,bb,cc']]></description><category></category></item><item><title><![CDATA[Tsql小细节]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/9497039</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/9497039</guid><author>mine3333</author><pubDate>Fri, 26 Jul 2013 15:52:43 +0800</pubDate><description><![CDATA[1.sql  取两位小数SELECT  CAST(CAST(5 AS DECIMAL(9, 2)) / CAST(3 AS DECIMAL(9, 2)) AS DECIMAL(9, 2))


              2.round  四舍五入的函数对应从哪一位数开始 四舍五入

                              




 
复制代码

]]></description><category></category></item><item><title><![CDATA[小细节记录]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/8845825</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/8845825</guid><author>mine3333</author><pubDate>Wed, 24 Apr 2013 17:29:44 +0800</pubDate><description><![CDATA[父窗体中添加与子窗体相同名称的控件，会导致子页面的同名控件没有寄宿
同一个解决方案中的转到定义无法查看源代码，需删除之前的引用，重新添加项目引用，而非dll.]]></description><category></category></item><item><title><![CDATA[WCF  ItemsSource 输入字符串格式不正确]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/8557218</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/8557218</guid><author>mine3333</author><pubDate>Wed, 30 Jan 2013 17:50:31 +0800</pubDate><description><![CDATA[在绑定之前设置 


           cobProvince.DisplayMemberPath = C_StateProvinceInfoEntity.PROVINCENAME_FIELD;
            cobProvince.SelectedValuePath = C_StateProvinceInfoEntity.PROVINCEID_FIELD;]]></description><category></category></item><item><title><![CDATA[winfrom  小技巧]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/8114595</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/8114595</guid><author>mine3333</author><pubDate>Fri, 26 Oct 2012 11:30:38 +0800</pubDate><description><![CDATA[设置grid 行数据不自动换行  rowsdefaultcellstyle 中的wrapmode  设置为false.]]></description><category></category></item><item><title><![CDATA[WPF中StringFormat 格式化 的用法]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/8073444</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/8073444</guid><author>mine3333</author><pubDate>Mon, 15 Oct 2012 15:54:42 +0800</pubDate><description><![CDATA[网格用法 my:DataGridTextColumnx:Name= PerformedDate Header= 执行时间 Binding= {BindingPerformedDate,StringFormat='yyyy年MM月dd日'} Width= 100 / my:DataGridTextColumnx:Name= LubricatingOilActualUsage Header= 润滑油用]]></description><category></category></item><item><title><![CDATA[C#验证类 可验证：邮箱,电话,手机,数字,英文,日期,身份证,邮编,网址,IP]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/7975840</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/7975840</guid><author>mine3333</author><pubDate>Thu, 13 Sep 2012 17:08:58 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/yongfa365/archive/2008/07/19/yongfa365_validator.html



namespace YongFa365.Validator
{
    using System;
    using System.Text.RegularExpressions;
    
    /**////]]></description><category></category></item><item><title><![CDATA[winfrom 窗体设置关闭按钮失效]]></title><link>https://blog.youkuaiyun.com/mine3333/article/details/7912832</link><guid>https://blog.youkuaiyun.com/mine3333/article/details/7912832</guid><author>mine3333</author><pubDate>Mon, 27 Aug 2012 16:44:38 +0800</pubDate><description><![CDATA[protected override CreateParams CreateParams
        {
            get
            {
                int CS_NOCLOSE = 0x200;
                CreateParams parameters = base.CreateParams;]]></description><category></category></item></channel></rss>