Communities for your favorite technologies. Explore all Collectives
Now available on Stack Overflow for Teams! AI features where you work: search, IDE, and chat.
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams
Find centralized, trusted content and collaborate around the technologies you use most.
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Get early access and see previews of new features.
I have a simple CTE x and I wish to select its contents into a view. Can you select into a view using the same type of syntax that you can for a table? i.e.
x
SELECT * INTO newTable FROM OldTable
Can new views be created dynamically like this?
select * into Paraplegia view from x
create view myView AS with x as (select 1 as num) select * from x
select * into Paraplegia view from x
didn't work