checking data type in sql server

1SELECT DATA_TYPE 
2FROM INFORMATION_SCHEMA.COLUMNS
3WHERE 
4     TABLE_NAME = 'yourTableName' AND 
5     COLUMN_NAME = 'yourColumnName'

1SELECT COLUMN_NAME,
2       DATA_TYPE,
3       IS_NULLABLE,
4       CHARACTER_MAXIMUM_LENGTH,
5       NUMERIC_PRECISION,
6       NUMERIC_SCALE
7FROM INFORMATION_SCHEMA.COLUMNS
8WHERE TABLE_NAME='your_table_name';