How insert more then 4000 characters?
I need insert many dates from tables to XML file, I use T-SQL, everything is OK, but in one step I can insert maximally 4000 character in uni-code.
Is there another way? Thanks' a lot.
I use such sequence T-SQL:
Declare@doc
XML,@ixml
nvarchar(4000)SELECT @ixml=(SELECT*FROM SAMPLE "d:SAMPLE"forXMLAUTO)SET @ixml='SET @Doc.modify(''declare namespace dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution";
declare namespace d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields";
insert ('
+@ixml+') into (dfs:myFields/dfs:dataFields)[1] '')'exec sp_ExecuteSql @STMT= @ixml, @PARAMS= N'@DOC XML OUT', @DOC= @DOC OUT
[2122 byte] By [JiriKrov] at [2008-3-7] 