|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Saturday, September 21, 2002 12:00 AM
Points: 20,
Visits: 1
|
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885,
Visits: 1
|
|
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"
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, December 09, 2008 5:58 AM
Points: 12,
Visits: 5
|
|
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
|
|
|
|
