SQLServer - Procedure com tabela temporária e cursor

gistfile1.sql

USE [BANK]

CREATE PROCEDURE [dbo].[spTbTempAndCursor] 
AS
BEGIN
	SET NOCOUNT ON;

	CREATE TABLE #TB_TEMP (
		[ID] [varchar](10) NOT NULL,
		[NAME] [varchar](10) NOT NULL
	) ON [PRIMARY]

	DECLARE @ID varchar(10), 
	        @NAME varchar(10)

	DECLARE USER_CURSOR CURSOR FOR SELECT ID, NAME FROM TB_USER OPEN USER_CURSOR

	FETCH NEXT FROM USER_CURSOR INTO @ID, @NAME

	WHILE @@FETCH_STATUS = 0 BEGIN

	    PRINT N'ID:' + @ID + ', NAME:' + @NAME;

	    FETCH NEXT FROM USER_CURSOR INTO @ID, @NAME
	END

	CLOSE USER_CURSOR
	DEALLOCATE USER_CURSOR
END