i have been delete dbo.spInsertChar who help me??

Results 1 to 1 of 1
  1. #1
    Member jnq1234 is offline
    MemberRank
    Sep 2006 Join Date
    dfasdLocation
    78Posts

    i have been delete dbo.spInsertChar who help me??

    who help me
    when i press new stored procedures and paste this text::::USE [GunzDB]
    GO
    /****** Object: StoredProcedure [dbo].[spInsertChar] Script Date: 04/19/2007 02:28:46 ******/
    set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[spInsertChar]
    @nAID INT,
    @nCharIndex INT,
    @szName nvarchar(32),
    @nSex INT,
    @nHair INT,
    @nFace INT,
    @nCostume INT
    AS
    BEGIN
    SET NOCOUNT ON;

    DECLARE @cnt INT
    SELECT @cnt=COUNT(*)
    FROM Character
    WHERE AID = @nAID

    DECLARE @cid INT
    SELECT @cid=COUNT(*)
    FROM Character

    INSERT INTO Character
    VALUES(@nAID,@szName,@cnt,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,null)
    END


    but it has a problem :::


    Msg 213, Level 16, State 1, Procedure spInsertChar, Line 22
    Insert Error: Column name or number of supplied values does not match table definition.



    note::::::::(i have been delete dbo.spInsertChar))




Advertisement