我有一个 SQL 查询
SELECT TABLE_SCHEMA + TABLE_NAME AS ColumnZ
FROM information_schema.tables
我希望结果应该是table_Schema.table_name
。
请帮帮我!我有一个 SQL 查询
SELECT TABLE_SCHEMA + TABLE_NAME AS ColumnZ
FROM information_schema.tables
我希望结果应该是table_Schema.table_name
。
请帮帮我!试一下这个:
SELECT TABLE_SCHEMA + '.' + TABLE_NAME AS ColumnZ
FROM information_schema.tables
SELECT Title,
FirstName,
lastName,
ISNULL(Title,'') + ' ' + ISNULL(FirstName,'') + ' ' + ISNULL(LastName,'') as FullName
FROM Customer
SELECT CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS ColumnZ FROM information_schema.tables
CONCAT
是SQL Server 2012中的新功能,因此可能无法提供给提问者。 - marc_s从 SQL Server 2017 开始,有一个 CONCAT_WS
操作符,用于带分隔符的字符串连接。
SELECT CONCAT_WS('.', TABLE_SCHEMA ,TABLE_NAME) AS ColumnZ
FROM information_schema.tables
SELECT TABLE_SCHEMA + '.' + TABLE_NAME
语句来连接表模式和表名。 - marc_s