By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

problem using ntext data type in OPENXML

P: n/a
Tom
Hi,

I've got problems using ntext data in a stored procedure (SQL-Server
2000):

create procedure testproc
@xmldata ntext
as
declare @Param ntext

exec sp_xml_preparedocument @idoc OUTPUT, @xmldata

select @Param=Param
from openxml(@idoc, '//ROOT/Parameters')
with (
Param ntext
)
But if I pass "Param" I'll receive an internal error. If "Param" and
"@Param" are declared as "varchar(2000)" everything works fine.

Any hints?

xpost & f'up
Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.