How to avoid text-to-date conversion mismatches

  In one of our previous posts we saw how different set options can affect execution plans and result sets. Now let’s see how to write our code in order to avoid text-to-date conversion mismatches. In this example we can see one string being converted to two different dates:   set language us_english select cast(’11/12/2012’…