InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 20 Mar 2010 11:32:54 GMT20http://www.sqlservercentral.com/Forums/Topic1606-53-1.aspx<P>Coming from a Sybase ASA world, I find UDF's absolutley invaluable.</P><P>Pity they can't do everything but ......!</P><P>The article served as a nice primer, thankyou </P><P>Geoff SutcliffeDatagaard Pty Ltd South Australia</P><P> </P>Mon, 24 May 2004 01:35:00 GMTDATAGAARDhttp://www.sqlservercentral.com/Forums/Topic1606-53-1.aspxHi thereComing 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 :)CheersChris Wed, 19 Dec 2001 18:53:00 GMTckempstehttp://www.sqlservercentral.com/Forums/Topic1606-53-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/achigrik/udfexamples.asp>http://www.sqlservercentral.com/columnists/achigrik/udfexamples.asp</A>Sat, 10 Nov 2001 00:00:00 GMTachigrik