开发者

how to call a scalar UDF?

开发者 https://www.devze.com 2023-01-30 13:24 出处:网络
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

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

精彩评论

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

关注公众号