Concat :- New function in sql server denali

SQL Server Denali has many new programming function
We will look at it one by one

Concat

Returns a string that is concaconcatenating  of two or more string values

Concat (, ,…

SELECT Concat (‘First’, ‘ ‘, ‘Second’, ‘ ‘, ‘Three’)

 

WE want tablename and columname with seperate  by .

Here is the query for it

SELECT Concat (Object_name(object_id), ‘.’, name),

       *

FROM   sys.columns