04 2011 档案

Linq 团队的问题
摘要：1.代码安全 AppliedComputerFullSearch string VIEWSTATE = xdoc.Root.GetDescendant(xns, "input", "id", "__VIEWSTATE").GetAttribute("value") + "&";2.代码高效 3.代码逻辑 listing.Price = priceTag.GetDescendant(xns, "b", "class", "priceLarg 阅读全文
posted @ 2011-04-22 19:07 mjg 阅读(162) 评论(0) 推荐(0)
Create Uniqueidentifier for string
摘要：数据清洗时常要生成GUID,使用下面代码可以实现-- 转化成GUIDIF OBJECT_ID('DBO.GET_Guid') IS NOT NULLDROP FUNCTION DBO.GET_GuidGOCreate Function DBO.GET_Guid(@s varchar(4000))returns uniqueidentifieras begin declare @guid uniqueidentifierset @guid = CONVERT(uniqueidentifier, HASHBYTES('MD5',@s))return @guidend 阅读全文
posted @ 2011-04-13 15:19 mjg 阅读(253) 评论(0) 推荐(0)