MS SQL

How can I create a user defined function

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2004

Posts: 573

Reputation: Dark_Omen is an unknown quantity at this point

Solved Threads: 5

Dark_Omen

Offline

Posting Pro

How can I create a user defined function

Apr 12th, 2005

Hello,

Can anyone explain to me how I can create a function that I can use in SQL.

Thanks

•

Join Date: Apr 2005

Posts: 158

Reputation: nicentral is an unknown quantity at this point

Solved Threads: 4

nicentral

Offline

Junior Poster

Re: How can I create a user defined function

Apr 12th, 2005

It's pretty easy.

CREATE FUNCTION MyFunction(@variableOne datatype)
RETURNS datatype
AS
BEGIN

-- put function logic here

RETURN @variable

END

Then to call the function, you would use it in any SQL statement. For example

SELECT FIELD1, MyFunction(FIELD2) as ALIAS
FROM SOMETABLE;

Hope this helps

Andy

Nobody believes the official spokesman, but everybody trusts an unidentified source.

-- Please do not PM me with questions about a thread. If you respond to a thread, then everyone can benefit.