Declare @Id NVARCHAR(36)
Declare @Name NVARCHAR(36)
DECLARE cur CURSOR FOR
SELECT Id,Name FROM TABLE
OPEN cur
FETCH next FROM cur INTO @Id,@Name
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @Id + @Name
FETCH next FROM cur INTO @Id,@Name
END
CLOSE cur
DEALLOCATE cur
