[Biojava-l] Database Management Systems

[Matt Harrington]

On Tue, Dec 19, 2000 at 09:49:08AM +1300, McCulloch, Alan wrote:

> * Apparent lack of user-defined stored functions (as opposed to procedures)
> in SQL Server. At least I'm darned if 
>   I can find any reference to them. This is a nuisance. They are very handy,
> in Oracle you can reference them in a 
>   SQL statement.


Alan,

This works in SQL Server 2000:

CREATE FUNCTION [OWNER].[FUNCTION NAME] (PARAMETER LIST)  
RETURNS (return_type_spec) AS  
BEGIN 
(FUNCTION BODY) 
END

is that what you're after?  it's pulled from the "User Defined Functions"
section of a database in Enterprise Manager.  I don't know if it was
availble prior to ss2000.

---Matt