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 - 2002-05-31 : 09:04:47
|
| Holger writes "I want to call a procedure (in my case sp_xml_preparedocument) with a ntext-parameter. The value I want to call the procedure with is stored in a ntext-column of a Table.The normal way I would do this is to fetch the value first into a local variable and then call the procedure with this variable. But this is not possible because it's not allowed to declare variables of type ntext.Can you help me?I use SQL Server 2000." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-31 : 09:51:36
|
| Have a look at [url]http://www.sqlxml.org/faqs.aspx?faq=42[/url]HTHJasper Smith |
 |
|
|
|
|
|
call procedure with parameter of type ntext