摘要：sp_configure 'clr enabled',1 /*0:close 1:open*/RECONFIGURE WITH OVERRIDEGOCREATE ASSEMBLY namefrom dllFullnameWITH PERMISSION_SET = SAFEGOcreate function RegEx_IsMatch(@text nvarchar(MAX), @pattern nvarchar(MAX),@ignoreCase int) RETURNS BIT AS EXTERNAL NAME staticMethodFullnamespaceGO 阅读全文

摘要：using Winista.Text.HtmlParser;using Winista.Text.HtmlParser.Lex;using Winista.Text.HtmlParser.Util;using Winista.Text.HtmlParser.Tags;using Winista.Text.HtmlParser.Filters;string HtmlText(string sourceHtml){ Parser parser = Parser.CreateParser(sourceHtml.Replace(System.Environment.NewLine,"&quo 阅读全文

摘要：https://msdn.microsoft.com/zh-cn/library/az24scfc(v=vs.110).aspx 贪婪匹配：由外向里查找匹配，如：.* 惰性匹配：由前向后查找匹配，格式是在贪婪表达式的后面加上一个?，如：.*? 后向引用(捕获模式): (?<name>pattern) 阅读全文

摘要：begin transactioninsert into ...save transaction first /*事务保留点*/insert into ...if @@error <> 0 rollback transaction first insert into ...if @@error <> 0 rollback transaction firstinsert into ...if @@error <> 0 rollback transaction firstcommit transaction 阅读全文