开发者

Is it possible to determine by way of T-SQL Query whether a sproc is CLR-based or regular T-SQL-based?

开发者 https://www.devze.com 2022-12-28 03:46 出处:网络
Hey all.I\'开发者_开发百科m integrating a CLR/Assembly-based sproc replacement for an existing sproc that lives within our production database, and I want to write an update script that only drops the

Hey all. I'开发者_开发百科m integrating a CLR/Assembly-based sproc replacement for an existing sproc that lives within our production database, and I want to write an update script that only drops the old T-SQL-based script and doesn't drop the new one if its already there. Is that possible?


When you query against sys.objects where type = 'P' (or sys.procedures), only SQL stored procedures are returned and not CLR functions. See sys.objects or more.

0

精彩评论

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