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.
The United States was the epicenter of the AIDS epidemic of the 1980s, first noticed by doctors in young gay men in Los Angeles, New York City, and San Francisco in 1981. Since then, 1.1 million people live with HIV, more than half of which are unaware of their infection.