Converting SQL Server to CLR Data Types : CLR « CLR « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. CLR
  3. CLR
CLR Data Type(s)      SQL Server Data Type(s)
SqlBytes              varbinary, binary
SqlBinary             varbinary, binary
SqlChars              nvarchar, nchar
SqlString             nvarchar, nchar
SqlGuid               uniqueidentifier
SqlBoolean            bit
SqlByte               tinyint
SqlInt16              smallint
SqlInt32              int
SqlInt64              bigint
SqlMoney              smallmoney, money
SqlDecimal            decimal, numeric
SqlSingle             real
SqlDouble             float
SqlDateTime           smalldatetime, datetime
SqlXml                xml








29.2.CLR
29.2.1.Converting SQL Server to CLR Data Types
29.2.2.--Enabling CLR Support in SQL Server 2005
29.2.3.Loading the Assembly Into SQL Server
29.2.4.Creating the CLR Stored Procedure
29.2.5.Creating a CLR Scalar User-Defined Function
29.2.6.Creating a CLR Trigger