摘要: using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Runtime.Serialization.Json;using System.IO;using System.... 阅读全文
posted @ 2015-03-14 17:04 wsion 阅读(249) 评论(0) 推荐(0)
摘要: /// /// Range Helper /// /// public class RangeHelper where T : IComparable { /// /// 为val返回指定范围内合法的值 /// ... 阅读全文
posted @ 2015-02-01 15:13 wsion 阅读(223) 评论(0) 推荐(0)
摘要: using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Collections;/// /// Page helper, default page size = 10/... 阅读全文
posted @ 2015-02-01 13:41 wsion 阅读(187) 评论(0) 推荐(0)
摘要: 1.根据出生日期计算当前已满周岁DECLARE @birth datetimeSET @birth='1990-01-01'SELECT (cast(convert(char( 8 ),GETDATE(),112) as int) - cast(convert(char(8),@birth,112)... 阅读全文
posted @ 2015-01-27 17:08 wsion 阅读(205) 评论(0) 推荐(0)
摘要: 语法:ROW_NUMBER() OVER(PARTITION BY GroupingColumnName ORDER BY WithinGroupOrderbyColumnName)按GroupingColumnName分组后,在组内按照指定(或默认)的排序规则生成行号。e.gSELECT * FR... 阅读全文
posted @ 2015-01-07 16:31 wsion 阅读(422) 评论(0) 推荐(0)
摘要: 首先,确保目标数据库的is_broker_enabled已经enabled。SELECT name, is_broker_enabled FROM sys.databases如果不是enabled,使用以下语句ALTER DATABASE DB_Name SET ENABLE_BROKERGO使用以... 阅读全文
posted @ 2015-01-05 15:43 wsion 阅读(361) 评论(0) 推荐(0)
摘要: Definitionif (!String.prototype.format) { String.prototype.format = function () { var args = arguments; return this.replace(/{(\d+)}/... 阅读全文
posted @ 2014-12-29 09:19 wsion 阅读(157) 评论(0) 推荐(0)
摘要: create function [dbo].[fn_GetQuanPin](@words nvarchar(2000)) returns varchar(8000) as begin declare @word nchar(1) declare @pinyin varc... 阅读全文
posted @ 2014-12-27 22:08 wsion 阅读(278) 评论(0) 推荐(0)
摘要: Q: I am trying to access the Site Settings of my SharePoint site, but I get a File Not Found error, although the rest of SharePoint works great. What ... 阅读全文
posted @ 2014-05-29 12:00 wsion 阅读(173) 评论(0) 推荐(0)
摘要: 对ViewState的误解有可能导致泄漏敏感数据ViewState攻击性能低下可扩展性低下ViewState做些什么根据Key为每个控件储值跟踪ViewState值 初始状态(initial state)的改变串行化和并行化存储的数据并存入到一个隐藏字段在回发期间自动重建ViewStateViewState不做什么自动持久化类中变量的状态对于回发请求,在页面加载的过程中记录状态信息在每次请求过程中使系统不重新填充数据ViewState不为所有的控件服务为你煮咖啡ViewState核心 1.ViewState储值ViewState只是一个属性名,它的类型是StateBag。ViewState属. 阅读全文
posted @ 2013-12-05 22:43 wsion 阅读(506) 评论(0) 推荐(0)