How to create table using select query in SQL Server

Question

I try to make 50-100 tables using SYS queries   SELECT windows release  windows service pack level          windows sku  os language version FROM sys dm os windows info OPTION  RECOMPILE       -- DEGISIRSE INSERT ETSIN AYNI ISE DEGISMESIN  -- Gives you major OS version  Service Pack  Edition  and language info for the operating system  -- SQL Server Services information  SQL Server 2008 R2 SP1 or greater  SELECT servicename  startup type desc  status desc   last startup time  service account  is clustered  cluster nodename FROM sys dm server services OPTION  RECOMPILE     -- Hardware information from SQL Server 2008  --  Cannot distinguish between HT and multi-core  SELECT cpu count AS  Logical CPU Count   hyperthread ratio AS  Hyperthread Ratio   cpu count hyperthread ratio AS  Physical CPU Count    physical memory in bytes 1048576 AS  Physical Memory  MB     sqlserver start time --  affinity type desc --  affinity type desc is only in 2008 R2  FROM sys dm os sys info OPTION  RECOMPILE     How to create table from SYS tables queries result

User · Answer

select  lt column list gt  into  lt table name gt  from  lt source gt  where  lt whereclause gt

User · Answer

An example statement that uses a sub-select    select   into MyNewTable from   select       from   SomeOtherTablename  where    EventStartDatetime  gt    01 JAN 2018       mysourcedata     note that the sub query must be given a name    any name    e g  above example gives the subquery a name of mysourcedata   Without this a syntax error is issued in SQL server 2012   The database should reply with a message like   9999 row s  affected

User · Answer

select  lt column list gt  into  lt dest  table gt  from  lt source table gt     You could do this way   SELECT windows release  windows service pack level          windows sku  os language version into   new table name FROM   sys dm os windows info OPTION  RECOMPILE

[sql] How to create table using select query in SQL Server?

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008