How to create a stored procedure in SQL Server that can determine the best data types for all...

I have been tasked with creating a stored procedure which would take the name of a table as a parameter and then determine the best data type for the columns in that table, based on the data that already exists in that table. Ideally the stored procedure would not only determine the best data types based on the data, but also alter said table to fit the recommended data types. Any input on how I can go about doing this? I am still fairly new to SQL Server so I want to make sure I create this procedure correctly.

Continue reading...