|
|
Posted by AJA on 03/28/07 11:35
> http://www.quicksqlserver.com/2007/03/openxml_more_th.html
It workink on small XML file but i have XML file largest than 10MB so there
must be declarations of about 5000 variables?
Have you any other idea??
I made new thread and sample sql which create dinamicly variables but the
same problem statement must have 8000- characters but for that file
must have much more :((
Best Regards
AJA
>
> --
>
> Jack Vamvas
> ___________________________________
> Advertise your IT vacancies for free at - http://www.ITjobfeed.com
>
>
>
> "AJA" <ajanospam74@gazeta.pl> wrote in message
> news:eu7tql$dff$1@inews.gazeta.pl...
>>> You should be able to do up to 8000 characters, reset where you have
>>> 1000 and replace it with 8000.
>>> If you have a requirement for more than 8000 , reply and I'll send you a
>>> stored procedure that handles this problem
>>
>> It will be about 20MB XML file. So more than 8000 characters. Thank you
>> for reply and I'm waiting for procedure.
>>
>> Best Regards
>> AJA
>>
>>>
>>> --
>>>
>>> Jack Vamvas
>>> ___________________________________
>>> Advertise your IT vacancies for free at - http://www.ITjobfeed.com
>>>
>>>
>>>
>>> "AJA" <ajanospam74@gazeta.pl> wrote in message
>>> news:ettb3e$9lj$1@inews.gazeta.pl...
>>>> Hello
>>>> I watchet some posts but did not find answer to my question : how
>>>> to import data from xml into mssql 2000 using t-sql?
>>>>
>>>> i tried:
>>>>
>>>> USE Northwind
>>>> if(object_id('dbo.test_xml') is not null)
>>>> drop table dbo.test_xml
>>>> go
>>>> create table dbo.test_xml (Id int identity(1,1), col1 text)
>>>> go
>>>> insert into test_xml(col1) values('')
>>>> go
>>>> declare @cmd varchar(512)
>>>> set @cmd = 'D:\Progra~1\Micros~3\MSSQL\Binn\TextCopy.exe /S /U
>>>> [user] /P [password] /D Northwind /F c:\pobierz.xml /T
>>>> test_xml /C col1 /I /W "where Id = 1"'
>>>> exec master..xp_cmdshell @cmd, 'no_output'
>>>> go
>>>> declare
>>>> @hdoc int
>>>> , @doc varchar(1000)
>>>> select @doc = col1 from dbo.test_xml
>>>> exec sp_xml_preparedocument @hdoc out, @doc
>>>> select @hdoc as hdoc
>>>> -- ...
>>>> select * from openxml(@hdoc, ...
>>>>
>>>> --...
>>>> exec sp_xml_removedocument @hdoc
>>>>
>>>> But my documet have more than 1000characters and more than max varchar.
>>>> So how to do that?
>>>>
>>>>
>>>> Best regards
>>>> AJA
>>>
>>>
>>
>
>
[Back to original message]
|