Answer to Question #172344 in Databases | SQL | Oracle | MS Access for william

Question

define in detail datatypes in SQL server?

Answer 1

A SQL variable is an object which can hold a single data value of a specific data types. It is used in batches and scripts.

Each column of the SQL required a name and datatype.

String datatype: char(size),VARCHAR(size),BINARY(size),VARBINARY(size), TINYBLOB, TINYTEXT, TEXT(size),BLOB(size) etc

Numeric datatype:

Bit(size), TINYINT(size), BOOL, BOOLEAN, SMALLINT(size),MEDIUMINT(size),INT(size) etc.

Date and Time Data Type:

DATE, DATETIME(fsp), TIMESTAMP(fsp), TIME(fsp), YEAR