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