User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
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 426,405 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,370 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: Programming Forums

Text data type troubles in T-SQL

•
•
Join Date: Mar 2004
Location: Brisbane
Posts: 632
Reputation: Slade has a spectacular aura about Slade has a spectacular aura about 
Rep Power: 7
Solved Threads: 6
Slade's Avatar
Slade Slade is offline Offline
Practically a Master Poster

Text data type troubles in T-SQL

  #1  
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 
  
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
Formerly known as Slade.
AddThis Social Bookmark Button
Reply With Quote  
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 1:33 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC