TRY_CONVERT

  • matthew.mcgiffen 73574

    Mr or Mrs. 500

    Points: 583

    Comments posted to this topic are about the item TRY_CONVERT

  • aakash214

    SSC Enthusiast

    Points: 112

    I have observed TRY_CONVERT to be slow in terms of performance. It would be good to do some comparative analysis for the same.

  • matthew.mcgiffen 73574

    Mr or Mrs. 500

    Points: 583

    Hi Aakash,

    I just ran a quick test converting a million integer values to varchars and didn't see much difference in performance. If you have an example where TRY_CONVERT is much worse than CONVERT I'd love to see it.

    Thanks,

    Matthew.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply