[dba-SQLServer] Any gut feelings?

On 3 Nov 2006 at 16:27, JWColby wrote:

> I guess I wrote this a little too quickly.  What I meant is, does SQL have
> anything like Access where you can with a query build a new table based on a
> handful of fields fro the source table, and having done that, have the
> destination field retain at least the same datatypes / data sizes in the
> destination table.  

"SELECT RecordPK, carpref1, carpref2  FROM MainTable INTO NewTable"



-- 
Stuart