table type

• mtl20144102

  Old Hand

  Points: 394

  More actions

  October 25, 2018 at 7:18 am

  #409150

  What kind of temporary table is MyTable? 

  
; WITH MyTable AS (

      SELECT * FROM Customer

  )

  It's different from 
  
SELECT * INTO #Temp FROM Customer


• NorthernSoul

  SSCertifiable

  Points: 6869

  More actions

  October 25, 2018 at 7:24 am

  #2011123

  It is a CTE or Common Table Expression. The link below gives you more detail about them

  https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-2017

  Thanks

• mtl20144102

  Old Hand

  Points: 394

  More actions

  October 25, 2018 at 7:32 am

  #2011126

  Thank you!