|
|
|
|
|
|
|
|
|
Inline UDF's in SQL Server
View or function, which should you use? Inline user defined functions are definitely interesting easy to learn how to use. Join Andy Novick for the quick intro that will have you creating these functions in no time at all!
|
|
|
|
Duration:
|
2
mins
21
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.13
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
|
|
Great.
|
|
Hope Schlais on
4/15/2009
Always comment as to performance scenario. Give a helpful performance tip.
|
|
Carla Wilson on
4/15/2009
I really like the idea of not only using a "view" with parameters, but also creating it dynamically inline. Very cool. I have to see what I can use it for right away.
|
|
Carla Wilson on
4/15/2009
Question: Is the Inline UDF available in SQL 2000, or just 2005+? This could be a work-around for not having CTEs in 2000.
|
|
|
Yes, Inline UDFs are available in SQL Server 2000.
|
|
|
I wish you could have spoken about SYSTEM Defined functions too.
|
|
|
What are the performance differences between UDFs and views?
|
|
|
love it
|
|
|
good
|
|
|
Little more explanation on topic
|
Must Be Logged In
|
|
|
|
|