a very simple help please

[yona1006]

hello peoples of RZ

I spend a few problems recently
whereby formatie the PC
I lost so much information
the thing I need is a query
not a big deal but since my server
and I need to add the user that are registered
silk to test all things
so I manually do the thing complicated
as there are on record over 1500 accounts and last long
so I ask the favor
for someone to give me a query to add silk to all
pls

and sorry for the inconvenience
excuse my English

[MentaL]

[Caipi]

Declare SilkCursor CURSOR
FAST_FORWARD FOR
SELECT JID FROM TB_User

OPEN SilkCursor

Declare @CurJID INT,
        @Silk INT = 5000; --> for 5k Silk

FETCH NEXT FROM SilkCursor INTO @CurJID

WHILE @@FETCH_STATUS = 0
    BEGIN
    IF exists (SELECT JID FROM SK_Silk WHERE JID = @CurJID)
        BEGIN
            UPDATE SK_Silk SET silk_own += @Silk WHERE JID = @CurJID
        END
    ELSE
        BEGIN
            INSERT INTO SK_Silk SELECT @CurJID, @Silk, 0, 0
        END
    FETCH NEXT FROM SilkCursor INTO @CurJID
    END
    
CLOSE SilkCursor

DEALLOCATE SilkCursor

SELECT 'Done!' 

[yona1006]

thx bro