Posted By

rengber on 02/18/09

Tagged

database

Versions (?)

Last Edited at 02/18/09 10:21pm

Statistics

Viewed 917 times

Favorited by 0 user(s)

Related snippets

Basic TSQL Cursor Syntax

/ Published in: SQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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

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

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.