Hi
i have post the code
How to get datatype of a column in SQL Server
Run The Procedure
=========================
Exec sp_FindDatatype 'Employee'
Create Procedure
===============
CREATE Proc sp_FindDatatype
@TblName varchar(50)
as
SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=@TblName