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.

Barry Felt on 8/25/2010

Terrific presentation with practical applications...