I need to create a table from select query result in the SQL Server, I have tried.
create table temp AS select.....
However, I am getting the error.
Incorrect syntax near the keyword 'AS'
You can use the following syntax to create a new table from the old table in the SQL server 2008.
Select * into new_table from old_table
Want to become a SQL Expertise? Register to this SQL Course and get certified.
E&ICT MNIT - Data Science and Machine Learning |
IIT Madras - Advance Certification in Data Science and AI |
E&ICT IIT Guwahati - Cloud Computing & DevOps |
E&ICT IIT Guwahati - Cyber Security |
E&ICT IIT Guwahati - Software Engineering & Application Development |
E&ICT IIT Guwahati - Big Data Analytics |
E&ICT IIT Guwahati - Full Stack Web Development |
E&ICT MNIT - AI and Machine Learning |
E&ICT IIT Guwahati - UI UX Design Strategy |
IIT Madras - Data Analytics for Business |
E&ICT IIT Roorkee - Cloud Computing & DevOps |
E&ICT MNIT - Cyber Security & Ethical Hacking |
E&ICT MNIT - Business Analyst & Project Management
Big Data Analytics Courses |
Data Science Courses |
Business Intelligence courses |
Best Salesforce Courses |
Cloud Computing Courses |
Best Digital Marketing Courses |
Programming Courses Online |
Database Certification Courses |
Project Management Certification Courses |
Best Web Development Certification courses |
Automation Trainings |
UI UX Course
Data Science Courses |
Best Artificial Certification Intelligence Course |
Machine Learning Training |
Python Course |
DevOps Certification Course |
AWS Training and Certification |
Azure Certification |
AWS DevOps Training |
Azure DevOps Certification Course |
Cyber Security Course |
Ethical Hacking Course |
Big Data Hadoop Certification |
SQL Course |
Salesforce Admin Certification |
Online Salesforce Developer Certification |
Selenium Training Online |
Business Analyst Course Online |
Data Analyst Certification course |
Best Microsoft Power BI Certification Course |
Tableau Course Online |
Linux certification Course |
Data Analytics Certification Course |
Digital Marketing Course |
Online Business Analytics Course |
Online Investment Banking Course |
Online Supply Chain Course |
Online Electric Vehicle Course
M. Tech in AI & ML |
M. Sc. in Data Science |
MBA in Big Data Management |
M. Sc. in Artificial Intelligence |
MBA in Business Administration |
MBA in International Marketing |
Master’s in Computer Science |
MBA in Finance and Accounting |
Master’s in Engineering Management |
Master of Science in Data Science |
MSC in Data Science
© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.