带有静态视图的游标-SQL Server

Question

我想首先说的是，我花了几个小时试图了解如何向这个游标添加静态视图，但我真的不了解游标的真正功能，所以我来这里寻求一些建议。这与我使用的类似，所以我希望足够清楚。

DECLARE @name VARCHAR(50),
@last_name VARCHAR(50)
DECLARE C_People CURSOR GLOBAL
FOR 
SELECT name, last_name
FROM People
OPEN C_People 
FETCH C_People INTO @name , @last_name
WHILE(@@FETCH_STATUS = 0)
BEGIN
PRINT 'Hello ' + @name + ' ' + @last_name
FETCH C_People INTO @name, @last_name
END
CLOSE C_People 
DEALLOCATE C_People 
GO

Answer 1

假设您想要一个视图，该视图必须返回一个带有"Hello"的列。。。

CREATE VIEW [dbo].[View_HelloPersons]
AS
SELECT       'Hello ' + Name + ' ' + Last_Name AS Something
FROM            dbo.People
-- you can access data from anywhere with
Select Something From View_HelloPersons

Answer 2

您可能指的是仅向前的光标-fast_forward通常是最快的：

DECLARE name CURSOR FAST_FORWARD FOR