Database Design

Text data type troubles in T-SQL

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2004

Posts: 634

Reputation: Slade has a spectacular aura about

Solved Threads: 7

Slade

Offline

Practically a Master Poster

Text data type troubles in T-SQL

Jun 24th, 2004

Ok here is the issue. I am getting this error when making my sql statement:

"Error 409: The assignment operator operation could not take a text data type as an argument"

Here is the code:

Help with Code Tags

(Toggle Plain Text)

  
CREATE procedure sf_GetArticle

 @ArtID int,
 @Title nvarchar(200) output,
 @Content text output,
 @Hits int,
 @HitText nvarchar(200) output,
 @UserID nvarchar(20) output
 
 
AS

SELECT

 @ArtID   =  ArtID,
 @Title   =  Title,
 @Content  = Content,
 @Hits   =  Hits,
 @HitText  =  HitText ,
 @UserID  =  UserID
 

FROM sf_articles
WHERE ArtID = @ArtID


IF @@ROWCOUNT = 0
 SET @ArtID = 0
GO

The ultimate goal of this is so I can use this stored procedure to grab these values and use them in asp .net using sql parameters, this method has worked for me before... but I have never used the text data type. It is absolutely needed as the maximum nvarchar of 8000 is simply not enough for what I want it to do.

I am a n00b in t-sql, please help