Author:

Author Bio:

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...

What is a Scalar UDF?

SQL Server allows us to create several different types of user defined functions to let us reuse code. Andy Novick explains what a scalar UDF is and provides some great examples of how to create and use them.

Video Information
Publish Date:	January 28, 2009
Length:	2:51
Skill Level:	100
Rating:	3.95 out of 5

After watching you should be able to answer these questions:

What kind of permissions need to be granted to a user defined function so that other users can use it?

How many values can be returned from a scalar user defined function?

You must be logged in to view this video.

Rate This Video:	12345
	1=Poor, 3=Good, 5=Excellent

Comments:

BC69ADFF3A on 1/29/2009

Were there prerequisites? If so I should have checked them. I am comfortable with UDM and SSAS, but this was over my head. I would recommend started with uses or why important.

Gerrard on 1/30/2009

the link is not working..

Bill Nicolich on 6/18/2009

Solid.

Dipak Saha on 7/14/2009

great topic

B60C5F1F21 on 8/24/2009

great for beginners

Tonci on 11/18/2009

You gave a good example of when to apply a scalar function. Thank you.

Larry Alexander on 12/9/2009

I am a student at Kaplan University online and am in a SQL Server 2008 course, undergrad. I need to see a udf scalar function that computes the distance in longitude and latitude. with parameters @sLat, @pLat, @sLon, @pLon with variable @distance as returned value in decimal datatype with scale and precision to hold a tenth of a mile. HELP!!

A Alagu Ganesh on 2/5/2010

Good


Must Be Logged In

References

Demos from Video

Zip file of the .SQL files from this video