title: Delete rows from CTE in SQL SERVER
body: <p>I have a CTE which is a select statement on a table.  Now if I delete 1 row from the CTE, will it delete that row from my base table?</p>
  
  <p>Also is it the same case if I have a temp table instead of CTE?</p>