小编典典

SQL Server,如何将两列合并为一列?

sql

我有一个SQL查询

SELECT TABLE_SCHEMA + TABLE_NAME AS ColumnZ 
FROM information_schema.tables

我希望结果应该是table_Schema.table_name

请帮帮我!!


阅读 40

收藏
2021-04-22

共1个答案

小编典典

试试这个:

SELECT TABLE_SCHEMA + '.' + TABLE_NAME AS ColumnZ 
FROM information_schema.tables
2021-04-22