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 |
Best Testing Courses |
Project Management Certification Courses |
Best Web Development Certification courses |
Automation Trainings |
Cyber Security Training Courses |
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 |
CEH course |
Big Data Hadoop Certification |
SQL Online 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
MCA Degree Program |
MBA Degree Program |
MBA HR Degree Program |
MBA IT Degree Program |
MBA Finance Degree Program |
MBA General Degree Program |
MSC in Data Science
© COPYRIGHT 2011-2022 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.