SQL Server Data Types - length data) Unicode nchar,...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
SQL Server Data Types Numeric data types: bigint, int, smallint (+/- 32000) , tinyint (0-255) float, real (floating point numbers) decimal/numeric (fixed precision numbers) smallmoney, money (4 decimal places, accurate for financial applications) Character data types Non-Unicode - char (fixed length), varchar(variable length), text (large variable
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: length data) Unicode nchar, nvarchar, ntext Binary data types bit (Boolean), binary, varbinary, image (Word, Excel, bitmaps, graphic files) Special data types Datetime (date and time data), timestamp (updated when row is updated),...
View Full Document

Ask a homework question - tutors are online