开发者

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)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜