I suspect that it would probably be quite fraught with issues but is there a quick and not too intensive way to find the datatype of a column in a table. ISNUMERIC() can do this for a subset of the values, but there aren't equivalents such as ISUNIQUEIDENTIFIER
or ISDATETIME as far as i know.
DBA, Datacruncher and Boardgamer
View Complete Post