SQL SERVER

Question

Hi Experts where does it store/assigned/Declard the CTE in SQL SERVER DB's memory-Exactly..............! other than Tempdb which one ! Thanks & Regards D.vijayabhaska ph-7676020160

maulin shah · Answer

Function procedure view definitions etc are stored in the database where they are created. This definition is stored on disk guaranteed.A CTE declared inside a stored procedure is therefore stored on disk.