Common Table Expression or CTEs was a very useful feature which got added from SQL 2005. Though they’re mostly associated to recursive query scenario, they can be used for scenarios involving iterative logic also. The…
Advantages of using sys.sql_modules view over syscomments
sys.sql_modules was a new catalog view which got introduced from SQL 2005 onwards. I’ve used it quite a lot in my day to day work. Just thought of sharing some of reasons why its preferred over syscomments view a. Finding object dependencies on…