Concat :- New function in sql server denali

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


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

No comments:

Post a Comment

Popular Posts