好，在使用视图之前，我还没有尝试过类似的方法，但是我通常要做的是使用临时表#table_name，全局表##table_name或声明的表@table_name，我可以轻松地完成您想做的事情.但是当然，这在很大程度上与我要工作的范围有关，我认为您可能希望在更大的范围内工作.我个人将在视图中进行检查现在！
:)

ok I havent tried something like that before USING a view, but what I usually do is to rather use either a temporary table #table_name, a global table ##table_name or a declared table @table_name and I can easily do what you wanted to do. But of course it largely has to do with the scope within which I want to work in, with views I would assume you would want to work in a larger scope..I''m personally going to check up on doing it in a view now!
:)