microsoft sql data types code example
Example 1: sql data types
BIT TINYINT SMALLINT INT BIGINT DECIMAL NUMERIC FLOAT REAL
DATE TIME DATETIME TIMESTAMP YEAR
CHAR VARCHAR TEXT NCHAR NVARCHAR NTEXT
BINARY VARBINARY IMAGE
CLOB BLOB XML JSON
Example 2: data types in sql
• number(num) - whole numbers up to num digits
• number(num,num2) - num whole numbers up to num2 decimals
• char(num) - fixed length character/string
• varchar2(num) - used for varying length data
• date - full date
• currency - used for prices