Create Table using Select query in SQL Server

Question

we have to try blow query but unable to create pls suggest on thiscreate table DemoTbl as select  from TableName where filedName

nagaraju60 · Accepted Answer

Dear pratikshirplease try below query Select  into newtable  from  oldtable or  SELECT  col1  col       ltlt select as many columns as you want        INTO New tableNameFROM    Source Table Name

kalpesh · Answer

pratikshir sayscreate table DemoTbl as select  from TableName where filedNameItrsquos not right way to create the table using this syntax If you need to create new table from existing table with same table structure then refer the below test querySQLSELECT INTO DemoTblFROM TableNamewhere filedName    Your condition value or for perticulare columnSELECT youecolumn1Nameyouecolumn2NameINTO DemoTblFROM TableNamewhere filedName    Your condition value

Create Table using Select query in SQL Server

Company

Explore

Follow us

Contact Us