According to the CTE documentation, Common Table Expression is a temporary result set or a table in which we can do CREATE, UPDATE, DELETE but only within that scope. That is, if we create the CTE in a Stored Procedure, we can’t use it in another Stored Procedure.
source https://www.c-sharpcorner.com/article/common-table-expressioncte-in-sql-server/
No comments:
Post a Comment