please help me

USE SRO_VT_ACCOUNT;
GO
INSERT INTO SK_SILK
(JID,
silk_own,
silk_gift,
silk_point)
SELECT JID,
'0',
'0',
'0'
FROM TB_User
WHERE not exists
(select * from SK_Silk
WHERE SK_SILK
.JID = TB_User.JID);
UPDATE SK_Silk SET silk_own=silk_own+10

at SRO_VT_ACCOUNT change to your account db name if you change it,
at silk_own=silk_own+10 change 10 to the silk value(amount) you need to add to all registered users .
 
Upvote 0
Back