Declaring Cursors

DECLARE @UserID int
DECLARE test_cursor CURSOR FOR

SELECT UserID FROM Users

OPEN test_cursor
FETCH NEXT FROM test_cursor INTO @UserID
WHILE @@FETCH_STATUS = 0
BEGIN

INSERT INTO Emails (UserID,Email) VALUES (@UserID, 'test@test.com')

FETCH NEXT FROM test_cursor INTO @UserID
END
CLOSE test_cursor
DEALLOCATE test_cursor