when you exec this procedure how do you access the result set programmaticall y?
EXEC sp_columns @table_name = 'table1', @table_owner = 'dbo', @column_name = 'column1'
I need to get to the data type of the column.
My ultimate goal is to have one function that will allow me to pass any column to it and return a varchar back to the originating sql statement formated for a report.
EXEC sp_columns @table_name = 'table1', @table_owner = 'dbo', @column_name = 'column1'
I need to get to the data type of the column.
My ultimate goal is to have one function that will allow me to pass any column to it and return a varchar back to the originating sql statement formated for a report.