I have a question about how the SQL server engine determines the types of calculated fields. For simple calculations I assume it's based on the types of the fields composing the query as they are defined in their tables, but what about a calculated field
in this form, for example: isnull(field-name,-99)? Is there a way I can change the engine's selection in the query?
View Complete Post