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

No comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts