Text data type troubles in T-SQL

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 370,613 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,098 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser:

Thread Tools Display Modes

Views: 9701 | Replies: 0

•

Join Date: Mar 2004

Location: Brisbane

Posts: 630

Reputation: Slade has a spectacular aura about

Rep Power: 7

Solved Threads: 6

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