How can I create a user defined function

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 363,560 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,928 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 5204 | Replies: 2

•

Join Date: Apr 2004

Posts: 555

Reputation: Dark_Omen is an unknown quantity at this point

Rep Power: 6

Solved Threads: 6

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

Location: Milwaukee, WI

Posts: 156

Reputation: nicentral is an unknown quantity at this point

Rep Power: 4

Solved Threads: 3

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.