DAP Relational Database Server II: Difference between revisions

Revision as of 21:11, 20 April 2009

@@ Line 3: / Line 3: @@
 == Data model representation ==
+=== Atomic (Simple) Types ===
+{| border="1" cellspacing="0"
+|+ [http://msdn.microsoft.com/en-us/library/ms187752.aspx Transact-SQL (Microsoft)]
+!Type !! Range !! Storage Bytes !! DAP equiv.
+|-
+|bigint || || 8 bytes || none
+|-
+|int || || 4 bytes ||
+|-
+|numeric || || ||
+|-
+|decimal || || ||
+|-
+| bit || || ||
+|-
+|smallint || ||  2 bytes ||
+|-
+|tinyint || || 1 bytes||
+|-
+| smallmoney  || ||  ||
+|-
+| money  || ||  ||
+|-
+| float || || 4 or 8 bytes ||
+|-
+| real  || || 4 bytes ||
+|-
+| date  || ||  ||
+|-
+| datetimeoffset  || ||  ||
+|-
+| datetime2  || ||  ||
+|-
+| smalldatetime  || ||  ||
+|-
+| datetime  || ||  ||
+|-
+| time  || ||  ||
+|-
+| char  || ||  ||
+|-
+| varchar  || ||  ||
+|-
+| next  || ||  ||
+|-
+| nchar  || ||  ||
+|-
+| nvarchar  || ||  ||
+|-
+| ntext  || ||  ||
+|-
+| binary   || ||  ||
+|-
+| varbinary  || ||  ||
+|-
+| image  || ||  ||
+|-
+| cursor  || ||  ||
+|-
+| timestamp  || ||  ||
+|-
+| hierarchyid  || ||  ||
+|-
+| uniquieidentifier  || ||  ||
+|-
+| sql_variant  || ||  ||
+|-
+| xml  || ||  ||
+|-
+| table  || ||  ||
+|}
 == Desired Features ==
 == Implementation Target ==