SQL CLR or SQLCLR is technology for hosting of the Microsoft . NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. This technology, introduced in Microsoft SQL Server 2005, allow users for example to create the following types of managed code objects in SQL Server in . NET languages such as C# or VB. NET.

PropertyValue
dbpprop:abstract
  • SQL CLR or SQLCLR is technology for hosting of the Microsoft . NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. This technology, introduced in Microsoft SQL Server 2005, allow users for example to create the following types of managed code objects in SQL Server in . NET languages such as C# or VB. NET. Stored procedures (SPs) which are analogous to procedures or void functions in procedural languages like VB or C, triggers which are stored procedures that fire in response to Data Manipulation Language (DML) or Data Definition Language (DDL) events, User-defined functions (UDFs) which are analogous to functions in procedural languages, User-defined aggregates (UDAs) which allow developers to create custom aggregates that act on sets of data instead of one row at a time, User-defined types (UDTs) that allow users to create simple or complex data types which can be serialized and deserialized within the database. The SQL CLR relies on the creation, deployment, and registration of . NET assemblies, which are physically stored in managed code dynamic load libraries (DLLs). These assemblies may contain . NET namespaces, classes, functions and properties.
  • SQL CLR SQL Common Language Runtime 是自 SQL Server 2005 才出現的新功能，它將. NET Framework中的CLR服務注入到 SQL Server 中，讓 SQL Server 的部份資料庫物件可以使用 . NET Framework 的程式語言開發（目前只支援VB. NET和C#），包括預存程序、使用者自訂函數、觸發程序、使用者自訂型別以及使用者自訂彙總函數等功能。
dbpprop:hasPhotoCollection
dbpprop:reference
rdfs:comment
  • SQL CLR or SQLCLR is technology for hosting of the Microsoft . NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. This technology, introduced in Microsoft SQL Server 2005, allow users for example to create the following types of managed code objects in SQL Server in . NET languages such as C# or VB. NET.
  • SQL CLR SQL Common Language Runtime 是自 SQL Server 2005 才出現的新功能，它將. NET Framework中的CLR服務注入到 SQL Server 中，讓 SQL Server 的部份資料庫物件可以使用 . NET Framework 的程式語言開發（目前只支援VB. NET和C#），包括預存程序、使用者自訂函數、觸發程序、使用者自訂型別以及使用者自訂彙總函數等功能。
rdfs:label
  • SQL CLR
  • SQL CLR
owl:sameAs
skos:subject
foaf:page
is dbpprop:redirect of