Re: Determining column type

Andrew,

Yes, you can look at table metadata, and it's not difficult, but as JK
so eloquently points out, that won't help you with 'columns' that are
function results or literals or something else that is not a column
defined in a table.

My bitching was just because I was using the ancient version of FreeTDS
that you get from the Ubuntu package management system. Once I'd built
and installed the FreeTDS version from CVS, everything was fine, and I
get just the same results as from the 'native client' driver on Windows,
which suit my purpose very well.

Steve

On Tue, 2011-11-29 at 09:37 -0500, Andrew H. Wakefield wrote:
> JK,
> 
> You are waxing very poetic these days! I am enjoying reading these 
> answers, not least because I keep learning new things.
> 
> However, it seems to me that there is another approach that might 
> satisfy the OP's needs. Why not query the metadata using the appropriate 
> Transact SQL commands? (I'd have to dig around a bit to remember exactly 
> how to do this, but IIRC, it is certainly not difficult.)
> 
> ahw
>