i want to create a table with all records and column names from tableA to tableB in sql server : <blockquote>
  <p>create table tableB as ( select * from tableA) 
  --this works in oracle but not in sql server</p>
</blockquote>
