TRY_CONVERT

• Matthew McGiffen

  SSChasing Mays

  Points: 653

  More actions

  May 28, 2018 at 10:00 pm

  #413332

  Comments posted to this topic are about the item TRY_CONVERT

• aakash214

  SSC Enthusiast

  Points: 122

  More actions

  May 28, 2018 at 10:37 pm

  #1992132

  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

  SSChasing Mays

  Points: 653

  More actions

  May 29, 2018 at 3:47 am

  #1992143

  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.