SQL SERVER – SELECT INTO with FileGroup or Partitionis Not Possible
- by Pinal Dave
The other day, I received an email from user and after a long time before I answer the question, I had to check the answer online.
Here is the question -
I want to create a new table based from old table, but when I execute following script it gives me an error. Is there anything I am missing in my syntax?
SELECT *
INTO NewTableName ON…