Select Into with partition

Transact-SQL
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.

1 Like