Wants to read ntext datatype in stored proc

• Vikas-198293

  SSC Enthusiast

  Points: 113

  More actions

  December 30, 2004 at 3:42 am

  #61510

  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

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 30, 2004 at 3:58 am

  #535379

  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]

• k_vasanthkumar

  Old Hand

  Points: 349

  More actions

  January 2, 2005 at 1:40 am

  #535557

  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