Requires all the table names and column names in the database to uppercase, the first thing that is first thought is to modify in the system table, the table name in the database is placed under the Sysobjects table, and the column name is placed in the syscolumns table. Usually the system table is unmodified, the system table is changed, and the prompt needs to turn the Allow Update configuration switch. Write the following script exec sp_configure 'allow update', '1'go
UPDATE syscolumns SET syscolumns.name = upper (syscolumns.name) WHERE syscolumns.name IN (SELECT syscolumns.nameFROM syscolumns, sysobjectsWHERE syscolumns.id = sysobjects.idAND sysobjects.xtype = 'U') GO
Update sysobjects set sysobjects.name = Upper (sysobjects.name) Where sysobjects.xtype = 'u'go
EXEC sp_configure 'allow update', '0'GO the result was wrong, and finally investigated and found to bring RECONFIGURE WITH OVERRIDE command to configure allow update, SQL Server Books Online describes it: Updates the currently configured (the config_value column in the sp_configure result set) value of a configuration option changed with the sp_configure system stored procedure. Because some configuration options require a server stop and restart to update the currently running value, RECONFIGURE does not always update the currently running value (the run_value column in the SP_CONFIGURE RESULT SET) for a Changed Configuration Value.
It turned out to be some, huh, huh.
