由于生产环境的需要在数据库中对比两个JSON的内容是否一样，由于Key存在位置不相符的情况无法通过简单的等于进行判断。为此采用SQLServer CLR功能，引入Newtonsoft.Json的方法进行对比，得到想要的结果。示例如下： select dbo.IsSameJson('{"ColA":"Value1", "ColB":"Value2"}', '{"ColB":"Value2", "ColA":"Value1"}') --结果：1 select dbo.IsSameJson('{"ColA":"Value1", "ColB":""}', '{"ColB":"Value2", "ColA":"Value1"}') --结果：0 附件中提供了创建CLR函数的相关脚本及c#源代码，有c#基础的同学可以自行完善修改，补充更多的JSON功能，没有基础想使用该函数的同学可以直接执行相关脚本获取该函数。

因工作时常在SQLSERVER进行http接口操作，涉及编码的转换问题和中文MD5的加密问题，在数据库中根本无法实现，经研究可以借助CLR功能实现一下函数。 附件中提供了源码、开启CLR脚本及直接注册一下函数的脚本，无c#基础的同学可以直接执行SQL脚本即可获得一下方法，若有开发能力则可自行研究。 --示例 Select dbo.UnicodeEncode('CSDN专业开发者社区') Select dbo.UnicodeDecode('CSDN\u4e13\u4e1a\u5f00\u53d1\u8005\u793e\u533a') Select dbo.UrlEncode('CSDN专业开发者社区') Select dbo.UrlDecode('CSDN%E4%B8%93%E4%B8%9A%E5%BC%80%E5%8F%91%E8%80%85%E7%A4%BE%E5%8C%BA') Select dbo.MD5Encrpty('CSDN专业开发者社区', '') --默认uft8 Select dbo.MD5Encrpty('CSDN专业开发者社区', 'GB2312')

CLR via C# 第4版 英文PDFKristin, words cannot express how /feel about our life together. cherish our family and all our adventures. I'm filled each day with love for Aidan (age 9)and Grant (age 5), you both have been an inspira- tion to me and have taught me to play and have fun Watching the two of you grow up has been so rewarding and enjoyable for me. am lucky to be able to partake in your lives. love and ap preciate you more than you could ever know Contents at a glance Introduction PART I CLR BASICS CHAPTER 1 The clr's execution model CHAPTER 2 Building, Packaging, Deploying, and Administering Applications and Types 33 chaPTeR 3 Shared Assemblies and Strongly Named Assemblies 65 PART I DESIGNING TYPES CHAPTER 4 Type Fundamentals 91 CHAPTER 5 Primitive, Reference, and Value Types 111 CHAPTER 6 Type and Member Basics 151 CHAPTER 7 Constants and fields 175 chaPTer 8 Methods 181 chaPTer 9 Parameters 209 CHAPTER 10 Properties 227 CHAPTER 11 Events 249 CHAPTER 12 Generics 265 CHAPTER 13 Interfaces 295 PARTⅢ ESSENTIAL TYPES CHAPTER 14 Chars, Strings, and Working with Text 317 CHAPTER 15 Enumerated Types and Bit Flags 361 CHAPTER 16 Arrays 373 CHAPTER 17 Delegates 391 CHAPTER 18 Custom Attributes 421 CHAPTER 19 Nullable value Types 441 PART IV CORE FACILITIES CHAPTER 20 Exceptions and state management 451 CHAPTER 21 The Managed Heap and Garbage Collection 505 CHAPTER 22 CLR Hosting and AppDomains 553 CHAPTER 23 Assembly Loading and reflection 583 CHAPTER 24 Runtime serialization 611 CHAPTER 25 Interoperating with WinRT Components 643 PAR V THREADING ChaPTEr 26 Thread basics 669 CHAPTER 27 Compute-Bound Asynchronous Operations 691 CHAPTER 28 IyO-Bound Asynchronous Operations 727 CHAPTER 29 Primitive thread Synchronization Constructs 757 CHAPTER 30 Hybrid Thread Synchronization Constructs 789 Index 823 Contents at a glance Contents Introduction XX PART CLR BASICS Chapter 1 The Clrs Execution Model 3 Compiling Source Code into Managed Modules Combining managed modules into assemblies Loading the Common Language Runtime 8 Executing Your Assembly's Code 11 IL and∨ erification 16 Unsafe Code The Native Code generator tool: ngen. exe 19 The Framework Class Library 22 The Common Type System The Common Language Specification Interoperability with Unmanaged Code 30 Chapter 2 Building, Packaging, Deploying, and Administering Applications and Types 33 NET Framework Deployment Goals 34 Building Types into a Module 35 Response Fil 36 A Brief Look at metadata 38 What do you think of this book We want to hear from you Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. To participate in a brief online survey, please visit microsoft. com/learning/booksurvey Combining Modules to Form an Assembly 45 Adding Assemblies to a Project by Using the Visual Studio IDE.51 Using the assembly Linker Adding Resource Files to an Assembly 53 Assembly Version Resource Information .54 Version numbers ..58 Culture Simple Application Deployment(Privately deployed Assemblies)...60 Simple Administrative Control(Configuration) 62 Chapter 3 Shared Assemblies and Strongly Named Assemblies 65 Two Kinds of Assemblies, Two Kinds of Deployment 66 Giving an Assembly a Strong Name 67 The global Assembly Cache 72 Building an Assembly That References a Strongly Named Assembly..74 Strongly named assemblies are tamper-Resistant 75 Delayed Signing Privately Deploying Strongly Named Assemblies How the Runtime Resolves Type References 80 Advanced Administrative Control( Configuration) 83 Publisher Policy control 86 PART I DESIGNING TYPES Chapter 4 Type Fundamentals 91 All Types Are Derived from System Object .91 Casting Between Types 93 Casting with the C# is and as Operators Namespaces and assemblies 97 How Things relate at Run time .101 Chapter 5 Primitive, Reference, and Value Types 111 Programming Language Primitive Types 111 Checked and Unchecked Primitive Type Operations 115 Reference Types and value Types 118 Boxing and Unboxing Value Types 124 Changing Fields in a Boxed Value Type by Using Interfaces and Why You Shouldnt Do This) 136 Object Equality and Identity 139 Object hash Codes .142 The dynamic Primitive Type ......144 Chapter 6 Type and member Basics 151 The Different Kinds of Type Members .151 Type visibilit 154 Friend assemblies 154 Member accessibility .156 Static Classes ...158 Partial Classes, Structures, and Interfaces .159 Components, Polymorphism, and Versioning 160 How the CLR Calls Virtual Methods, Properties, and Events 162 Using Type Visibility and Member Accessibility Intelligently...166 Dealing with Virtual Methods When Versioning Types 16 Chapter 7 Constants and Fields 175 Constants 175 Fⅰe|ds ...177 Chapter 8 Methods 181 Instance Constructors and Classes(Reference Types) 181 Instance Constructors and Structures(Value Types) 184 Type Constructors 187 Contents x Operator Overload Methods 191 Operators and Programming Language Interoperability 193 Conversion Operator Methods 195 Extension method 198 Rules and guidelines ....,200 Extending Various Types with Extension Methods 201 The Extension Attribute 203 Partial Methods 204 Rules and guidelines 207 Chapter 9 Parameters 209 Optional and Named Parameters 209 Rules and guidelines 210 The defaultParameter value and optional Attributes 212 Implicitly Typed Local Variabl 212 Passing parameters by reference to a Method 214 Passing a variable Number of arguments to a Method 220 Parameter and Return Type Guidelines 223 Const-nes 224 Chapter 10 Properties 227 Parameterless Properties 227 Automatically Implemented Properties 231 Defining Properties Intelligently 232 Object and collection Initializers 235 Anonymous Type .237 The System. Tuple type 240 Parameterful Properties 242 The performance of calling property accessor Methods 247 Property Accessor Accessibility 248 Generic prop A roperty Access 248

搭建WSUS使用报告功能，需要安装 MICROSOFT REPORT VIEWER 2012 的 ReportViewer.msi和 Microsoft System CLR Types for Microsoft SQL Server 2012 的 SQLSysClrTypes.msi ，找了一圈获得能用的，好东西分享一下。

JeffreyRichter《CLR via C#（第4版）》英文版+源码。针对CLR和.NET Framework 4.5进行深入、全面的探讨，并结合实例介绍了如何利用它们进行设计、开发和调试。

帮助你了解C#的语法糖,熟悉更多的底层原理 本书针对CLR和.NET Framework 4.0进行深入、全面的探讨，并结合实例介绍了如何利用它们进行设计、开发和调试。全书5部分29章。第Ⅰ部分介绍CLR基础，第Ⅱ部分解释如何设计类型，第Ⅲ部分介绍基本类型，第Ⅳ部分以实用特性为主题，第Ⅴ部分花大量篇幅重点介绍线程处理。 通过本书的阅读，读者可以掌握CLR和.NET Framework的精髓，轻松、高效地创建高性能应用程序。

针对 CLR和.NET Framework 4.5进行深入、全面的探讨， 并结合实例介绍了如何利用它们进行设计、开发和调 试。全书5部分共29章。第Ⅰ部分介绍CLR基础，第Ⅱ 部分解释如何设计类型，第Ⅲ部分介绍基本类型，第 Ⅳ部分以核心机制为主题，第Ⅴ部分重点介绍线程处 理。 通过本书的阅读，读者可以掌握CLR和.NET Framework的精髓，轻松、高效地创建高性能应用程序。

由浅入深，透视CLR和.NET精髓，知其然 鞭辟入里，探究CLR和.NET机理，知其所以然 深入探究并掌握CLR(公共语言运行时)、C#和.NET开发，其实很简单。 享有全球盛誉的编程专家Jeffrey Richter，微软.NET团队长达十几年的资深技术顾问，在本书中以简洁流畅的语言将其数十年的经验和心得娓娓道来，独到而深刻的见解，深思熟虑之后形成的洞见，这些都让人醍醐灌顶，为日后构建健壮、可靠和响应快的应用程序与组件奠定良好的基础。

未能加载文件或程序集“Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Cul ,里面包括Microsoft® System CLR Types for Microsoft® SQL Server® 2012

NET CLR via C#(第4版)中文版（百度网盘链接地址）