Do SQL
Chọn New Query
Code:
USE [PS_GameData]
GOdrop procedure [dbo].[usp_Save_Char_Item_Add_E]GOSET QUOTED_IDENTIFIER OFFGOSET ANSI_NULLS ONGO/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/CREATE Proc usp_Save_Char_Item_Add_E@CharID int,@ItemUID bigint,@Bag tinyint,@Slot tinyint,@ItemID int,@Type tinyint,@TypeID tinyint,@Quality int,@Gem1 tinyint,@Gem2 tinyint,@Gem3 tinyint,@Gem4 tinyint,@Gem5 tinyint,@Gem6 tinyint,@Craftname varchar(20) = '',@Count tinyint,@MaketimeZ varchar(50),@Maketype char(1)ASDECLARE @Maketime as datetimeSELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)--SET NOCOUNT ONIF(@Quality >= 5000)BEGINSET @Quality=0ENDINSERT INTO CharItems(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,gem5, gem6, craftname, [count], maketime, maketype)VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)IF(@@ERROR = 0)BEGINRETURN 1ENDELSEBEGINRETURN -1END--SET NOCOUNT OFFGOSET QUOTED_IDENTIFIER OFFGOSET ANSI_NULLS ON GO
sau đó nhấn Execute Query

epvp