表中所有列的所有数据的 SQL Server 大写 [英] SQL Server UPPERCASE for all data for all columns in the table

问题描述

我想知道如何将表的所有列名和其中的值的所有数据转换为大写.数据可能包含 int 但它会忽略它.我所做的事情是手动将第 1 列更新为 1，这很耗时.

I would like to know how to convert all data to UPPERCASE for all columns name and the values in them for a table. The data may contain int but it will ignore it. Something I did was to manually update column 1 by 1 which is time consuming.

有没有类似的说法:

UPDATE cust SET cust.* = UPPER(cust.*)

谢谢~

推荐答案

动态 SQL 可能是您唯一的选择.像这样的事情应该使用 FOR XML 查询 INFORMATION_SCHEMA.COLUMNS:

Dynamic SQL is probably your only option. Something like this should would using FOR XML querying INFORMATION_SCHEMA.COLUMNS:

declare @query varchar(max)
set @query = ''

select @query =
  STUFF((
    select ';UPDATE ' + table_name + ' SET ' + column_name + ' = UPPER(' + column_name + ')'
    from INFORMATION_SCHEMA.COLUMNS
    order by table_name, column_name
    for xml path('')
        ), 1, 1, '')

execute(@query);

SQL 小提琴演示

这篇关于表中所有列的所有数据的 SQL Server 大写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！