In my database course at Marshall University, I helped my professor with a side project involving Cancer research data that has been collected since 1973 by the National Cancer Institute. My first job was to take the SEER data and load it into a postgreSQL database.
The job was simple enough. The only problem? The data files were in SAS format. Basically the format was CRLF delimited entries composed of fixed-length fields. Here is a list of the fields and lengths that I used for the script.
I received metadata for a SQL Server 2008 R2 database which contained the system_type_id but not the data type itself. I ran a bunch of queries and logged the results to obtain a list of system_type_ids and the corresponding datatypes.
I looked on MSDN and was unable to find a list so I compiled one for usage for you google-ninjas who may find it handy.