Select and Insert into a temporal table data from a view SQL Server 2008
I have a view in SQL, and I want to select some data depending o开发者_运维百科n certain conditions , so is it possible to do
SELECT * INTO #TABLE_S FROM VIEW_TABLE
Or How do I insert VIEW data into a temporal table in SQL Server 2008?
This'll work as is written. Am I missing the point of the question?
Note that if #TABLE_S
already exists then you should instead use INSERT INTO #TABLE_S SELECT * FROM VIEW_TABLE
.
精彩评论