Painting Blue Code
Simple, self-explanatory code snippets.
2012-11-13
TSQL - Creating a view that uses a CTE
create
view
vTest1
as
with
v1
(
a
)
as
(
select
1
as
a
)
select
*
from
v1
;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment