Stored Proc Parameter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Quintis Venter (quintis_at_weblife.co.za)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 18:25:21 +0200

Hi there

Does anybody know of a good workaround for the 8000 char limit on SP
parameters?

Background... I'm retrieving huge amounts of data from a local news service.
The data is returned as XML and is processed by a stored proc, using
sp_xml_preparedocument. The problem is that the data length often exceeds
8000 characters. The only thing I can think of is processing the XML
elements individually and calling the stored proc for each, but that takes
forever. Any ideas?

Regards,
Quintis

Relevant Pages

  • Re: XML Import options
    ... If you pass the content of the file from the client to the server ... > stored proc directly, you can use NTEXT/TEXT as stored proc parameters! ... >> when XML was ...
    (microsoft.public.sqlserver.xml)
  • Re: Random file access -cont
    ... I use a text file format similar to CSV. ... for reasonably small amounts of data - a few thousand records - but it ... recommend XML unless the data volume is very small. ... .Net Compact Framework MVP ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: XML Import options
    ... and then call the procedure from your client code while passing the content ... >> stored proc directly, you can use NTEXT/TEXT as stored proc parameters! ... >>> I have a text parsing routine on the front end written many years ago ... >>> when XML was ...
    (microsoft.public.sqlserver.xml)
  • RE: Bad SQL Stored Proc Return Message
    ... If you select Operations -> Messages from the HAT menu, ... I know that the stored proc has to return an XML message ... > Received unexpected message type '' does not match expected type ...
    (microsoft.public.biztalk.general)
  • Re: Unknown token received from SQL Server when using FOR XML
    ... > I've got a problem with a stored proc using the FOR XML ... Are you getting this message in Query Analyzer? ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)