how to call a scalar UDF?
i have created the udf to strip HTML from sql fields from here: link text
i am trying to run an update on my table where the defects_from_oracle.Description field has html
my sql is:
update defects_from_oracle
set Description = udf_StripHTM开发者_JAVA百科L(Description)
where did i go wrong? i get error:
'udf_StripHTML' is not a recognized built-in function name.
you missed the dbo. prefex
update defects_from_oracle
set Description = dbo.udf_StripHTML(Description)
精彩评论