Forum Discussion
jenson245
Oct 07, 2024Copper Contributor
Bulk alter SQL column data value in MS-SQL2019
Complete command to alter SQL column data value. Hi, A newbie here, how to bulk update data in SQL column? For example my database name is "abcDB" I have multiple tables in "abcDb" that start ...
rodgerkong
Oct 08, 2024Iron Contributor
Only 20 tables, Copy & Paste 19 times SQL code and change table name will faster than find a "simplest way" 😂jenson245
olafhelper
Oct 09, 2024Bronze Contributor
... and will be more safe.
If the column is part of a unique index, the update may (will) fails.
If the column is part of a unique index, the update may (will) fails.