declare @EntityName as varchar(100)

    declare DepNameCursor Cursor FAST_FORWARD 
    FOR select top 100 MailName from DepNameExt

    OPEN DepNameCursor
    FETCH NEXT FROM DepNameCursor
    INTO @EntityName

    WHILE @@Fetch_Status = 0 
    BEGIN 

        INSERT INTO [UDC].[dbo].[Entity]
           ([Name])
        VALUES
           (@EntityName)

        FETCH NEXT FROM DepNameCursor
        INTO @EntityName
    END

    CLOSE DepNameCursor
    DEALLOCATE DepNameCursor

http://msdn.microsoft.com/en-us/library/ms190028.aspx

Minimal syntax for cursor use.  See URL for SQL 2005 options and improvements.

Basic TSQL Cursor Syntax

database

SQL