Remove this line:
Code:
TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;
Remove also this entire block:
Code:
IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
(UserUID,GameAccount,OneTimePassword,OTPExpireDate,DelCharPWD,CreateDate)
VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END
Instead of removing you could also put '-- ' before each line
Eg:
Code:
-- TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;