Varchar Were Cut Somehow!!!

Hi All,



I am trying to save a data into table

this is the table

   task_id    int    4   

    group_id    int    4   

    from_name    varchar    50   

    from_address    varchar    50   

    email_subject    varchar    100   

    body_format    tinyint    1   

    body_content    varchar    8000   

    priority    tinyint    1   

    create_date    datetime    8   

notice body_content is varchar 8000. I am using store procedure to save it



CREATE PROCEDURE sp_AddEmailTask (

@GroupId    int,

@FromEmail    varchar(50),

@Subject    varchar(100),

@Format        int,

@Body        varchar(7000)



)

AS

Set nocount on



insert into email_task

(

group_id,

from_address,

email_subject,

body_format,

body_content,

create_date

)

values

(

@GroupId,

@FromEmail,

@Subject,

@Format,

@Body,

getdate()

)



set nocount off

GO





However, somehow the body_content were cut. After saving sucessly, I
see the data in body_content is not what I want to save. Can anyone
explain this?



Thanks very much in advance.

Jusitn