I made database numeric[10,0] for userid but I m inserting string data type so there is a error show that ' Error converting data type varchar to numeric.' so plz how I can solve this problem...

CREATE TABLE [dbo].[tbl_binary7](
    [sno_no] [int] IDENTITY(1,1) NOT NULL,
    [sponser_id] [numeric](10, 0) NULL,
    [ibo_id] [numeric](10, 0) NULL,
    [placement] [int] NULL,
    [ibo_title] [nchar](10) NULL,
    [ibo_fname] [nvarchar](50) NULL,
    [ibo_lname] [nvarchar](50) NULL,
    [ibo_dob] [datetime] NULL,
    [cibo_title] [nchar](10) NULL,
    [cibo_fname] [nvarchar](50) NULL,
    [cibo_lname] [nvarchar](50) NULL,
    [cibo_dob] [datetime] NULL,
    [address1] [nvarchar](50) NULL,
    [address2] [nvarchar](50) NULL,
    [state] [nvarchar](50) NULL,
    [city] [nvarchar](50) NULL,
    [panno] [nvarchar](12) NULL,
    [pincode] [numeric](10, 0) NULL,
    [mob] [numeric](10, 0) NULL,
    [email] [nvarchar](50) NULL,
    [bankName] [nvarchar](50) NULL,
    [acc_no] [nvarchar](50) NULL,
    [ifsc_code] [nvarchar](50) NULL,
    [appling] [numeric](10, 0) NULL,
    [doj] [datetime] NULL,
    [abc] [nvarchar](50) NULL,
    [xyz] [nvarchar](50) NULL,
 CONSTRAINT [PK_tbl_binary7] PRIMARY KEY CLUSTERED
(
    [sno_no] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER PROCEDURE [dbo].[sp_InsertIBO]
	(
	@sponser_id  varchar(50),
	@ibo_id   varchar(50),
    @placement nvarchar(5),
    @ibo_title  nchar(10),
    @ibo_fname nvarchar(50),
    @ibo_lnamer nvarchar(50),
    @ibo_dob Datetime,
    @cibo_title nchar(10),
    @cibo_fname nvarchar(50),
    @cibo_lname nvarchar(50),
   -- @cibo_dob   datetime,
    @address1 nvarchar(50),
    @address2 nvarchar(50),
    @state nvarchar(50),
    @city nvarchar(50),
    @panno nvarchar(50),
    @pincode varchar(50), 
    @mob nvarchar(50),
    @email nvarchar(50),
    @bankName nvarchar(50),
    @acc_no nvarchar(50),
    @ifsc_code  nvarchar(50),
    @doj  datetime
	)
AS
BEGIN
	 insert into tbl_binary7
	 (
	 sponser_id,
	ibo_id,
    placement,
    ibo_title,
    ibo_fname,
    ibo_lname,
    ibo_dob,
    cibo_title, 
    cibo_fname,
    cibo_lname, 
   -- cibo_dob,
    address1,
    address2,
    state,
    city,
    panno,
    pincode, 
    mob, 
    email,
    bankName,
    acc_no,
    ifsc_code,
    doj
	  )
	  values
	  (
	  @sponser_id ,
	@ibo_id,
    @placement,
    @ibo_title,
    @ibo_fname,
    @ibo_lnamer,
    @ibo_dob,
    @cibo_title, 
    @cibo_fname,
    @cibo_lname, 
  --  @cibo_dob,
    @address1,
    @address2,
    @state,
    @city,
    @panno,
    @pincode, 
    @mob, 
    @email,
    @bankName,
    @acc_no,
    @ifsc_code,
    @doj
	  );
END