SQL Server，如何将两列合并为一列？

Question

我有一个SQL查询

SELECT TABLE_SCHEMA + TABLE_NAME AS ColumnZ 
FROM information_schema.tables

我希望结果应该是 table_Schema.table_name。

请帮帮我!!

Answer 1

试试这个:

SELECT TABLE_SCHEMA + '.' + TABLE_NAME AS ColumnZ 
FROM information_schema.tables