satyajit
Reputation: 2700
Using Temp table in A VIEW
I need a clarification on whether we can use Temp tables in VIEWS?
Upvotes: 2
Views: 2053
Answers (1)
gbn
Reputation: 432261
No, you can't.
A view takes a single SELECT statement (which includes UNION of course).
Upvotes: 4
Related Questions
- Alternative to using temp table/temp variables or CTE inside a view in SQL Server
- Creating temporary view from a temporary table in SQL Server
- sql query using temp table
- Unable to create view with Temporary tables
- Create VIEW using temp table
- Alternative to using temp tables in a view
- Create a View from select statement that uses multiple temp tables in T-SQL to remove the need for the temp tables
- Using a Temporary Table in a View in Order to Combine Two Queries
- Using a temp table in a view
- What are the concerns of having Temp/variable tables inside a view?