Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I am copying TEXT columns to another table where the destination column is VARCHAR(MAX).
It appears that this is an implicit conversion and that I do not need to write an explicit CAST for it.
Is this correct?
As detailed in the excellent Microsoft Documentation, conversions from text to varchar can indeed be implicit.
Required, but never shown