The script below shows an example query for data that have been converted from lower case, but it only changed the data on one column in the table.
Use MYF601T
Go
UPDATE ROAD_LINE
SET NAM = UPPER(NAM)
However, the following script that I'm trying to write is to convert all on all columns on all tables, but the result generated with errors.
Use MYF601T
Go
UPDATE INFORMATION_SCHEMA.TABLES
SET INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA = UPPER(INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA
How to do this for all tables and all columns inside?
Use a dynamic query to update all the column content to
upper
case.Query