November 10, 2001 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/achigrik/udfexamples.asp
December 19, 2001 at 6:53 pm
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"
May 24, 2004 at 1:35 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply