sao tặng zen cho nv khởi tạo ko đc nhỉ?

[tyemday]

 begin
   INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, 
     Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,  MDate, LDate, Quest, DbVersion, Leadership )
   SELECT @AccountID As AccountID, @Name As Name, 400, 300, @Class As Class, 
    Strength, Dexterity, Vitality, Energy, Inventory,MagicList,  Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
    getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership
   FROM  DefaultClassType WHERE Class = @Class 

ko thấy tặng zen đâu cả

[Alehap2010]

cái này vào mssql, tbl character, chọn edit with design j đó
Chỗ column money hay tên j tương tự, để ý xuống dòng default value, nhập vào số zen tặng khi tạo char là đc

[lieuthunguyet]

begin
INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership,money )
SELECT @AccountID As AccountID, @Name As Name, Level, 300, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,50000000 <= nhập số Zen muốn tặng vào.

[tyemday]

begin
INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership,money )
SELECT @AccountID As AccountID, @Name As Name, Level, 300, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,50000000 <= nhập số Zen muốn tặng vào.

lỗi ko đc mới hỏi chứ cha 30 charrrrrrrrrrrrrrrrrr

[tyemday]

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa