开发者

SQL Server UDF refresh

开发者 https://www.devze.com 2023-04-11 03:39 出处:网络
I have altered the column datatype in one of my tables from int to decimal. I have a UDF referencing the columns of this table.

I have altered the column datatype in one of my tables from int to decimal.

I have a UDF referencing the columns of this table.

How can I ensure my UDF 开发者_JAVA技巧returns decimals rather than int without having to re-create it?

(For view, I know we can use sp_refreshview, not sure about UDF).

Thanks, Rashmi


I assume you are talking about an inline TVF in which case you can use

EXEC sp_refreshsqlmodule 'YourTVF'
0

精彩评论

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