"CREATE TABLE AS SELECT" statement in SQL SERVER

Hello,

In SQL-Server, I'm trying to find the equivalent of the following SQL statement:

      "CREATE TABLE employees AS SELECT * FROM all_emp"

I know you can do this with to create a view in SQL SERVER, but is hasn't worked with a table.

ThanksStart Free Trial