Some Useful UDFs for SQL Server 2000

  • achigrik

    SSCommitted

    Points: 1812

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

  • ckempste

    SSCoach

    Points: 17983

    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

    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

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply