SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT function

Just a day before I was presenting at Virtual Tech Days and I wanted to demonstrate the current time to audience using SQL Server Management Studio, I ended up a quick error. If any of you ever tried to concat multiple values of different datatype this should not be surprise to you.

SELECT 'Current Time ' + GETDATE()

I quickly modified script to following workaround and my script worked right away.

SELECT 'Current Time ' + CAST(GETDATE() AS VARCHAR(20))

Current Time Dec 20 2011  7:00PM

However, I instantly realized that I can use SQL Server 2012 function which can right fit for this situation.

SELECT CONCAT('Current Time ', GETDATE())

I have previously written in detail article about SQL Server 2012 CONCAT function over here additionally, I have written quick guide on 14 new functions of SQL Server Denali.

Watch a quick video relevent to this subject:

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

10 thoughts on “SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT function

  1. hi pinal,

    am new to this blog, please let me knw the book name in which all topics shld cover. topics like : backup and restore, attach and detach, export and import, log shipping, mirroring , replication, clustering and finally performance tuning … plse let me knw to my mail id [email removed]

  2. hi pinal,

    am having a query, please tel the steps for this query..

    The database is used by a group of individuals. It appears to now be locked. Is there any way to tell who is the owner of XYZ ?

    And say me steps to unlock the database. to my mail id [email removed]

    thankyou..

  3. >Vinod Kumar

    >The trick is in using this with PRINT statement more than the SELECT statement. Give it a try :) …

    where is the trick? did you mean to replace select with print statement?

    If yes, then I tried the same thing using print statement, but still it gives the same error.

    Following is the print statement
    PRINT ‘Current date’ + GETDATE()

    Following is the error:
    Conversion failed when converting date and/or time from character string.

    Please reply.

    Thanks,
    Joe

  4. Hi Pinal,

    I am having Denali CTP 3. When i am trying concat function or new introduced functions, this will give me error that function not found. Can you give me
    version information on which you test concat function.

    My version information is below

    Microsoft SQL Server Management Studio 11.0.1440.19

    Thanks
    Vinay Kumar

  5. Pingback: SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT « SQL Server Journey with SQLAuthority

  6. Pingback: SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video « SQL Server Journey with SQL Authority

  7. Pingback: SQL SERVER – Weekly Series – Memory Lane – #008 « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s