Re: 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 425,885 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 2,135 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: Programming Forums

How can I create a user defined function

•

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.

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Statistics

Members: 425,885

Users Online Now: 2,135

Active IRC Users: 25

Forum Threads: 136,212

Forum Posts: 691,846

Code Snippets: 904

Blogs: 149

Blog Entries: 2,295

Directory Links: 565

DaniWeb Home > Forums > Web Development > Databases > MS SQL > How can I create a user...

Re: How can I create a user defined function

How can I create a user defined function

Re: How can I create a user defined function