copy from one table to another, with sampling
select * into table1X from tableX tablesample (10 percent) -- 10% of the page space, not rows select * into table1X from tableX tablesample (1000) -- 1000 lines, not the same select * into table1X from tableX tablesample (10 percent) repeatable (205) -- returns same values
quick way to copy a table into another table. Also, of course, can create the table first, then use insert rather than select.