什么是sql server中的View和with common_table_expression之间的差异？ [英] Whats The Diffrance between View And WITH common_table_expression in sql server?

问题描述

我是SQL SERVER的新手而且Usaaly我在VIEW中存储了选择查询结果但是最近

我想出我们也可以用`WITH`条款存储我们的查询结果所以Waht是实际的区别



创建视图为`SQL SELECT QUERY`



AND



WITH（Comman Table Expression）

AS

`SQL SELECT QUERY`



我们何时应该使用哪一个

解决方案

视图是SQL服务器中存储的东西。 cte仅存在于过程中，实际上只能使用一次。 Ctes也支持递归，而视图则不支持递归。视图用于创建常用视图。在单个sql块中使用cte是为了提高可读性。

请参阅： - http://www.dotnet-tricks.com/Tutorial/sqlserver/X517150913-Difference-between-CTE-and- Temp-Table-and-Table-Variable.html [ ^ ]



这将很好地解释你..

I Am New To SQL SERVER And Usaaly I Stored Select Query Result In VIEW But Recently
I figured Out We Can Also Store Our Query Result with `WITH` Clause So Waht is The Practical Difference Between

CREATE VIEW AS `SQL SELECT QUERY`

AND

WITH (Comman Table Expression)
AS
`SQL SELECT QUERY`

And When Should We Use Which One

解决方案

A view is something store in SQL server. A cte exists only in a procedure, and in fact can only be used once. Ctes also support recursion, which views do not. A view is used to create a commonly used view. A cte is used for the benefit of readability in a single block of sql.

See:- http://www.dotnet-tricks.com/Tutorial/sqlserver/X517150913-Difference-between-CTE-and-Temp-Table-and-Table-Variable.html[^]

This will explain you nicely...

这篇关于什么是sql server中的View和with common_table_expression之间的差异？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！