Question: I have a SQL query

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

```

I want the result should be `table_Schema.table_name`.

help me please!!

Answer: 
Try this:

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

```
From SQL Server 2017 onwards, there is `CONCAT_WS` operator, to concatenate with separators.

```sql
SELECT CONCAT_WS('.', TABLE_SCHEMA ,TABLE_NAME) AS ColumnZ 
FROM information_schema.tables

```