|
|
|
|
|
|
|
|
|
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.
|
|
|
|
Duration:
|
2
mins
51
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
3.99
out of 5
|
|
Publish Date:
|
January 28, 2009
|
|
|
|
About the Author
|
|
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...
|
|
References
|
|
Comments
|
|
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.
|
|
|
the link is not working..
|
|
Bill Nicolich on
6/18/2009
Solid.
|
|
|
great topic
|
|
|
great for beginners
|
|
|
You gave a good example of when to apply a scalar function. Thank you.
|
|
|
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!!
|
|
|
Good
|
Must Be Logged In
|
|
|
|
|