quick question is there any way in SQL server 2000 to get the type of an field ... ie something like
select ID, "TypeOf"(ID), Name, "TypeOf"(Name) from blah_table
returning something like
ID Name
---- ------- -------- --------
1 integer Andy nvarchar
3 integer Susan nvarchar
41 integer Sam nvarchar
etc....
???????
Thanks in advance
select ID, "TypeOf"(ID), Name, "TypeOf"(Name) from blah_table
returning something like
ID Name
---- ------- -------- --------
1 integer Andy nvarchar
3 integer Susan nvarchar
41 integer Sam nvarchar
etc....
???????
Thanks in advance