8-SQL Server 2000-2

8-SQL Server 2000-2 - 8 SQL Server2000 8.1 8.1.1 Int (...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 8 SQL Server2000 8.1 8.1.1 Int ( integer ) int integer -231 -2 147 483 648 231-1 2 147 483 647 Smallint -215 -32 768 215-1 Tinyint 0 255 SQL Server Real 7 Float 15 -1.79E-308 1.79E+308 Decimal numeric Decimal numeric 2 17 -1038-1 1038-1 Char char ( n ) Varchar varchar ( n ) char 255 Nchar nchar ( n ) Nvarchar nvarchar ( n ) Datetime 1753 1 1 9999 12 31 23 59 59 Smalldatetime datetime 1900 1 1 2079 6 6 Text 1 231- 1 2 147 483 647 Ntext text Image 231- 1 2 147 483 647 Money money 4 -922337213685477.5808 922337213685477.5808 922337213685477....
View Full Document

This note was uploaded on 01/09/2012 for the course CS CS273 taught by Professor Xifengyan during the Spring '11 term at UCSB.

Page1 / 99

8-SQL Server 2000-2 - 8 SQL Server2000 8.1 8.1.1 Int (...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online