开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜