Yesterday, I was working on an application where we have to store unicode characters in existing database. So our requirement was to switch all varchar column within the database to Nvarchar. There were around 22 tables and manually changing each one would be tedious task. So here is what we did – DECLARE @T VARCHAR(255) [...]