Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Some Useful UDFs for SQL Server 2000 Expand / Collapse
Author
Message
Posted Saturday, November 10, 2001 12:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 21, 2002 12:00 AM
Points: 20, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/achigrik/udfexamples.asp


Post #1606
Posted Wednesday, December 19, 2001 6:53 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!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"
Post #23752
Posted Monday, May 24, 2004 1:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 01, 2012 9:39 PM
Points: 12, Visits: 10

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

 




Post #117248
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse