Just to add to this library of answers a much better solution for any other nomadic inquisitors who may happen upon this post. If you have access to the stored procedures on the MSSQL Server, by FAR the EASIEST way to do this is to call the sp_columns system stored procedure.
| WASHINGTON. WASHINGTON A new estimate of how many Americans have the AIDS virus puts the number at about 1.1 million, the U.S. Centers for Disease Control and Prevention said on Thursday.
Overall, the CDC estimates that more than 1 million people are living with HIV in the U.S., and that 21% are unaware of their infection. More than 18,000 people with AIDS still die each year.