Article: Intro to User Defined Functions (Updated)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

Article Discussion

Article: Intro to User Defined Functions (Updated)

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-07 : 18:42:41

Garth Wells sends us this article on User Defined Functions. It's taken mainly from his book, Code-Centric: T-SQL Programming with Stored Procedures and Triggers , about programming Microsoft SQL Server. He also has a web site for the book with sample chapter downloads. Thanks for the article Garth!

Article Link.

filisosa
Starting Member

1 Post

Posted - 2008-02-13 : 15:54:23

I am trying to do this in SQL Server 2005 and it does not work the same. First it tells me that the object system_function_schema does not exist. Ant then I use the sys schema, but it tells me that I am not the owner of the object "sys".

CREATE FUNCTION fn_dtt ( @as_fecha_ddmmyyyy varchar(12) )
RETURNS Datetime
with schemabinding AS
BEGIN
return convert( datetime, @as_fecha_ddmmyyyy, 103 )
END

go

exec sys.sp_changeobjectowner 'fn_dtt', 'sys'

This is not working, any ideas ?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-14 : 06:01:31

filisosa,

This forum is not for posting questions, just for comments and discussions on article posted. Please create separate thread for your question.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources