Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-09 : 18:07:05
|
George writes "I have sReturnOut as a VARCHAR as an OUTPUT field. I want to convert it to text because 8000 is not enough! But it won't let me change it to text because the local variable @sGeorge isn't allowed, DOH!
If you can provide an answer that will be great. I'm still in TSQL not ADO so haven't tried it that way yet.
ALTER PROCEDURE sp_HTMLReport(
@sReturnOut VARCHAR(8000) = '' OUTPUT
) as
set @sReturnOut = 'Stupid text data type'
GO
Declare @sGeorge VARCHAR(8000)
Declare @sTest int
exec sp_HTMLReport @sReturnOut = @sGeorge OUTPUT
select ReturnValue = @sGeorge
GO" |
|
|
|
|
|
How to use text datatype! ps. Its urgent!!!