When a property return value or method return value is an array, sp_OAGetProperty or sp_OAMethod returns a results set to the client. (Method output parameters cannot be arrays.) These procedures scan all the data values in the array to determine the appropriate SQL Server datatypes and data lengths to use for each column in the results set. For a particular column, these procedures use the datatype and length required to represent all data values in that column.
When all data values in a column share the same datatype, that datatype is used for the whole column. When data values in a column use different datatypes, the datatype of the whole column is chosen based on the following table.
int | float | money | datetime | varchar | |
---|---|---|---|---|---|
int | int | float | money | varchar | varchar |
float | float | float | money | varchar | varchar |
money | money | money | money | varchar | varchar |
datetime | varvhar | varchar | varchar | datetime | varchar |
varchar | varchar | varchar | varchar | varchar | varchar |