출처 : http://uliasz.com/2011/04/sql-data-types-vs-c-data-types/
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 | 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) | user-defined type | None |
table | None | None |
cursor | None | None |
timestamp | None | None |
xml | SqlXml | None |
'컴퓨터 > SQL Server' 카테고리의 다른 글
BLOB (0) | 2015.09.30 |
---|---|
Datetime to Binary in C# (CLR Function) (0) | 2015.09.30 |
SQL Server 형변환 (0) | 2015.09.09 |
MSSQL Msg 10327 해결방법 (0) | 2015.06.01 |
MSSQL 계산열 (0) | 2014.12.10 |