4

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.

SELECT * 
INTO newTable
FROM OldTable

Can new views be created dynamically like this?

2

1 Answer 1

6
create view myView
AS
with x
as
(select 1 as num)
select * from x

Not the answer you're looking for? Browse other questions tagged or ask your own question.