|
|
Posted by Tom on 03/25/07 17:02
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
--
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
Navigation:
[Reply to this message]
|