Some Useful UDFs for SQL Server 2000

• achigrik

  SSCommitted

  Points: 1812

  More actions

  November 10, 2001 at 12:00 am

  #157620

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/achigrik/udfexamples.asp

• ckempste

  SSCoach

  Points: 17983

  More actions

  December 19, 2001 at 6:53 pm

  #421322

  Hi there

  Coming form an Oracle world, UDF's are very restrictive and tend to be a half cocked effort. I have this sneaking feeling that MS is not expending much effort in t-sql (ie. where is proper exception handling! which is fundamental to any language). Not being able to use temp tables, call stored procs etc is a right pain and makes the functions useful for only the basic operations.

  I personally believe UDF's was a last minute add in that tends to highlight MS push to the .Net version of sqlserver where stored procs etc can be in VB, C#, C++ etc that are much more feature rich.

  Anyhow, good article all the same

  Cheers

  Chris

  
  Chris Kempster
  www.chriskempster.com
  Author of "SQL Server Backup, Recovery & Troubleshooting"
  Author of "SQL Server 2k for the Oracle DBA"

• DATAGAARD

  Grasshopper

  Points: 22

  More actions

  May 24, 2004 at 1:35 am

  #507422

  Coming from a Sybase ASA world, I find UDF's absolutley invaluable.

  Pity they can't do everything but ......!

  The article served as a nice primer, thankyou

  Geoff Sutcliffe

  Datagaard Pty Ltd

  South Australia