PDA

View Full Version : xin query SQL Sro_VT_ACCOUNT



trangham1
05-02-14, 11:44 PM
gọi là xoá hết những cái cần thiết để cho open . không còn thông tin gì. thánk

htc1991
06-02-14, 06:26 AM
USE [SRO_VT_ACCOUNT]GOTRUNCATE TABLE [dbo].[__SiegeFortressStatus__]TRUNCATE TABLE [dbo].[_BlockedUser]TRUNCATE TABLE [dbo].[_CasGMChatLog]TRUNCATE TABLE [dbo].[_Notice]TRUNCATE TABLE [dbo].[_Punishment]TRUNCATE TABLE [dbo].[_ServiceManagerLog]TRUNCATE TABLE [dbo].[_ShardCurrentUser]TRUNCATE TABLE [dbo].[_SMCLog]TRUNCATE TABLE [dbo].[QuaySoEpoint]TRUNCATE TABLE [dbo].[SK_CharRenameLog]TRUNCATE TABLE [dbo].[SK_DownLevelLog]TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]TRUNCATE TABLE [dbo].[SK_ItemSaleLog]TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]TRUNCATE TABLE [dbo].[SK_ResetSkillLog]TRUNCATE TABLE [dbo].[SK_Silk]TRUNCATE TABLE [dbo].[SK_SilkBuyList]TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]TRUNCATE TABLE [dbo].[SR_ShardCharNames]TRUNCATE TABLE [dbo].[TB_Net2e]TRUNCATE TABLE [dbo].[TB_Net2e_Bak]TRUNCATE TABLE [dbo].[tb_partnerInfo]TRUNCATE TABLE [dbo].[tb_paygate_trans]TRUNCATE TABLE [dbo].[TB_User]TRUNCATE TABLE [dbo].[TB_User_Bak]TRUNCATE TABLE [dbo].[Test_HN]UPDATE [dbo].[_ShardService] SET ShardID = '64'