Multistatement UDF's in SQL Server

Multistatement user defined functions are an interesting way to package and reuse code. This video by well known author Andy Novick shows you what multistatement user defined functions are and how to create them in your SQL Server database. Worth watching!

Andrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site ht...

Dave Patterson on 5/20/2009

Excellent examples, quick and clear, thanks!

Christian Bahnsen on 5/20/2009

perfect timing! I'm just getting started with UDFs, and these videos are a godsend. The TSQL gods (and JumpstartTV) were smiling on me this morning.

Inland IT on 5/20/2009

nice

Caleb Bell on 7/16/2009

Thanks for pointing out the helpful "generate months" UDF!

Max on 10/18/2009

Thanks.

eileen on 1/18/2010

great!!

A Alagu Ganesh on 2/5/2010

Good

Michael on 8/25/2010

I really appreciate what you provide. These videos are very helpful indeed. The only thing I would improve on is the server bandwidth. It can be frustrating to have to wait several times during a video for the server to catch up.

stan on 8/25/2010

Good examples. Thanks.

Dennis Allen on 8/25/2010

I would like to know more about the consequences of using implicit table definitions verses explicit. -- example of what I mean when I say implicit CREATE FUNCTION dbo.DateRange( @min date, @max date ) RETURNS TABLE AS RETURN ( SELECT N+1 AS id, DateAdd( day, N, @min ) AS value FROM dbo.Tally WHERE N BETWEEN 0 AND DateDiff( day, @min, @max ) )

Alexander on 8/25/2010

Excellent video!!! I didn’t know about the grant select … public it’s good to know.

Paradoxical on 8/25/2010

Terrific presentation with practical applications...

Ludwig on 12/31/2010

execellent

Sneha on 1/3/2011

Good video...it would be good if there is a way to access the sample code

Amar0009 on 9/8/2011

Rich example.... Thanks.

David Overall on 10/31/2011

Great Tutorial on Multi-Statement UDf's!!!

chandrasekhar on 10/31/2011

very good video

Dan on 10/31/2011

great!

Inland IT on 10/31/2011

nicely done

Kevin Boles on 10/31/2011

People, DO NOT EVER USE SCALAR UDFS like this!!!! There are umpteen ways they screw you. They are NOT integrated into the optimizer/engine, they prevent getting good statistical estimates by optimizer, very often get row-by-row processing under the covers, statistics IO and graphical query plan from SSMS don't tell the truth about what is happening, void use of parallelism in query plan, etc. In the past 5 years I have made more money fixing UDF problems at client than I have from any other single performance related problem! I also wrote a chapter for the SQL Server MVP Deep Dives 2 book entitled Death by UDF. If you think you want to use UDFs PLEASE read that chapter first!!

Dennis Stephani on 10/31/2011

Pretty basic stuff, but I find user defined functions so helpful I give it a good+ rating. Hope others benefit from them.

Vince on 10/31/2011

Hard to hear sound

Vince on 10/31/2011

Hard to hear sound