Databaseyi Temizlemek icin Query Analyzer Kod

CREATE PROCEDURE [dbo].[DB_TEMIZLE] AS

TRUNCATE TABLE ACCOUNT_CHAR
TRUNCATE TABLE CURRENTUSER
TRUNCATE TABLE DELETED_USERDATA
TRUNCATE TABLE KNIGHTS
TRUNCATE TABLE KNIGHTS_RATING
TRUNCATE TABLE KNIGHTS_USER
TRUNCATE TABLE TB_USER
TRUNCATE TABLE USERDATA
TRUNCATE TABLE WAREHOUSE
TRUNCATE TABLE USERDATA_SKILLSHORTCUT
TRUNCATE TABLE USER_SAVED_MAGIC
TRUNCATE TABLE USER_RENTAL_ITEM
TRUNCATE TABLE KNIGHTS_ALLIANCE
TRUNCATE TABLE RENTAL_ITEM
TRUNCATE TABLE RENTAL_ITEM_LIST
TRUNCATE TABLE USER_MANNERPOINT_RANK
TRUNCATE TABLE USER_PERSONAL_RANK
TRUNCATE TABLE USER_KNIGHTS_RANK
TRUNCATE TABLE PREMIUM_SERVICE

TRUNCATE TABLE KING_BALLOT_BOX
TRUNCATE TABLE KING_ELECTION_LIST
TRUNCATE TABLE KING_SYSTEM
TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD

TRUNCATE TABLE ITEMLER
TRUNCATE TABLE GOKHAN
TRUNCATE TABLE HERO_USER
TRUNCATE TABLE HACKTOOL_USERLOG


DECLARE @Day tinyint
DECLARE @Month tinyint
DECLARE @Year smallint

SET @Day = DAY(GETDATE())
SET @Month = MONTH(GETDATE())
SET @Year = YEAR(GETDATE())

INSERT INTO KING_SYSTEM VALUES(1,7,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL)
INSERT INTO KING_SYSTEM VALUES(2,7,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL)
GO