SQLTeam.com | Weblogs | Forums

Select Into with partition


#1

Hi,

I know that is MSSQL PDW, we can CTAS a a new table with partition and index. How can i archive that with MSSQL 2014?

Thx


#2

usually close enough:

SELECT ...
INTO new table
FROM old table

#3

yea select into is close enough.....but partition and index was not tag along =(


#4

true, you'll have to wait for 2016 for that and add indexes later.