Can I save a whole table to a SQL
server database using SQL Passthrough technology.

The server is SQL Server.

What my idea was is something like.

'create table temp using select * from mytable'

which is the Oracle command.
But the question is 1) How do I do this
on a SQL Server
and two.

How can I upload a whole table to the SQL Server.