471,107 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,107 software developers and data experts.

The assignment operator operation cannot take a ntext data type as an argument

I've a question about ntext and text. How do you use them in a stored procedure? When I try to use an ntext data type in a proc i get this error -

'The assignment operator operation cannot take a ntext data type as an argument' -

this is the proc;
Expand|Select|Wrap|Line Numbers
  1. CREATE PROCEDURE test_content 
  2.  
  3. @sno int OUTPUT,
  4. @commens ntext OUTPUT
  5.  
  6. AS
  7.  
  8. SELECT  @comments = full_text FROM content
Mar 23 '09 #1
1 3278
Frinavale
9,735 Expert Mod 8TB
What type of database are you using?

Is your problem being caused by the "commens" type-o on line 4 in the above posted stored procedure?
Mar 23 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by Edward Diener | last post: by
1 post views Thread by Tony Johansson | last post: by
7 posts views Thread by Sean | last post: by
11 posts views Thread by anongroupaccount | last post: by
13 posts views Thread by Daniel W | last post: by
34 posts views Thread by Chris | last post: by
20 posts views Thread by TimeHorse | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.