Regarding sql functions

• boobalanmca07

  SSC Enthusiast

  Points: 117

  More actions

  November 26, 2012 at 7:37 am

  #267179

  how to use sql function in sql server

  the sql function is format()

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 26, 2012 at 7:39 am

  #1562237

  Please don't post multiple threads for the same problem.

  No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1388609-149-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  November 26, 2012 at 7:41 am

  #1562239

  Format function is not available in SQL Server 2005.

  It was introduced in 2012, check the BOL (Books On Line, alias help or documentation)

  http://msdn.microsoft.com/en-us/library/hh213505.aspx

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2