Wants to read ntext datatype in stored proc

  • Hi,

    Wants to read an ntext column and assign to local variable in stored procedure in sql 2000. But unable to do. As such I know that ntext cannot be read and assign if length of data is greater then 8000.

    My problem is I am sending mails and mail content body is stored in ntext field and mail length is greater then 8k. For that I am using sql mail and that fires from job as per scheduled time and job invokes store proc from which mails are going out one by one to recipients. In delivered mail content gets cut.

    Please let me know if there is any workaround of the problem.

    Thanks.

    Vikas

  • A quick search on this site (hint, hint ) returns this, which might be useful:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=7798

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Hi,

    TSQL has a problem that u cannot have a variable of TEXT/NTEXT datatype.I think the best way would be use a temp table

    Create #SqlMailBody(MailBody TEXT)

    and insert all the data into this text column and u can retrieve them as u require.

     

    Regards,

    Vasanth Kumar

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply