I want find that the ntext column data string have more than 2000 characters. I need to truncate those string to segment with 200 character, then put those segments along with their table_name and column_name to another table. Maybe need to use cursor? If so, how to use it?
It is almost always a bad idea to "seek and sunder" data, splitting it into smaller pieces solely to make it into smaller pieces. I've done it more than once, but I've always regretted doing it in the long run.