sql server data type and CLR data type
来源:互联网 发布:上市公司资本结构优化 编辑:程序博客网 时间:2024/06/06 19:51
SQL Server data type
CLR data type (SQL Server)
CLR data type (.NET Framework)
varbinary
SqlBytes, SqlBinary
Byte[]
binary
SqlBytes, SqlBinary
Byte[]
varbinary(1), binary(1)
SqlBytes, SqlBinary
byte, Byte[]
image
None
None
varchar
None
None
char
None
None
nvarchar(1), nchar(1)
SqlChars, SqlString
Char, String, Char[]
nvarchar
SqlChars, SqlString
SQLChars is a better match for data transfer and access, and SQLString is a better match for performing String operations.
String, Char[]
nchar
SqlChars, SqlString
String, Char[]
text
None
None
ntext
None
None
uniqueidentifier
SqlGuid
Guid
rowversion
None
Byte[]
bit
SqlBoolean
Boolean
tinyint
SqlByte
Byte
smallint
SqlInt16
Int16
int
SqlInt32
Int32
bigint
SqlInt64
Int64
smallmoney
SqlMoney
Decimal
money
SqlMoney
Decimal
numeric
SqlDecimal
Decimal
decimal
SqlDecimal
Decimal
real
SqlSingle
Single
float
SqlDouble
Double
smalldatetime
SqlDateTime
DateTime
datetime
SqlDateTime
DateTime
sql_variant
None
Object
User-defined type(UDT)
None
Same class that is bound to the user-defined type in the same assembly or a dependent assembly.
table
None
None
cursor
None
None
timestamp
None
None
xml
SqlXml
None
- sql server data type and CLR data type
- sql server data type
- SQL Server DB Type and CLR Type
- ADO Data Type mapping between Access, SQL Server, and the .NET Framework.........
- Data Type
- Data Type
- DATA TYPE
- Data Type
- sql server data type conversion - 案例 ( 一 )
- data-type,data-value
- [SilkTest]ANYTYPE data type and AnyWin Class
- Data Type Choices and Query Efficiency
- Delphi Data Type to C# Data Type
- enum data type
- windows data type
- PLI Data Type
- DB2 Data Type
- data type : 数据类型
- ZOJ 1221 Risk
- Struts2_code behind 配置
- eclipse 启动问题
- Windows Embedded CE Developer Center
- 人类无法抗拒的10种心理
- sql server data type and CLR data type
- 关于vs2003调试时提示:试图运行项目时出错:无法启动调试 没有正确安装调试器。请运行安装程序安装
- SPI详解
- atoi的方法实现函数
- LESSON 7 ATTACK ANALYSIS part II
- 虚拟机下Linux安装图解之二:虚拟机的创建
- C# 使用Enter键登录
- 经典十五课
- MFC 单文档中添加按钮控件