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.
HIV/AIDS is a global pandemic. As of 2012, approximately 35.3 million people have HIV worldwide with the number of new infections that year being about 2.3 million. This is down from 3.1 million new infections in 2001. Of these approximately 16.8 million are women and 3.4 million are less than 15 years old.