OK, the "xfdf" tag means that first, you have to add another level into your .query to include the root(xfdf) tag. And secondly, the "xfdf" tag is imposing an...

The script generator does not always work (bugs, fails on certain syntaxes), also cannot be automated and isn't very flexible. Plus there are things that it will not even...

There is no "xfdf" tag in there.

sweetdeal42 (9/3/2008)

---

/* select XML fields into name-value pair for assignment to variables */

(select field.query('data(@name)').value('.', 'varchar(100)') as FieldName

,fields.field.query('value').value('.', 'varchar(100)') as FieldValue

from @OMSA.nodes('/fields/field') fields...

Post the XML here as an attachment. Don't try to add it to the text of your post.

If I add "ORDER BY name" the error goes aways but it only lists one routine.

Christian Buettner (9/3/2008)

---

Try this one:

DECLARE @A nvarchar(max)

SELECT @A = ISNULL(@A,'') + OBJECT_DEFINITION(object_id) + '

GO

' FROM sys.procedures

SELECT CAST(@A AS XML)

Explanation:

1. Use OBJECT_DEFINITION to get the full script of the object...

Glad I could help.

Just remember in the future though: If you want to be able to retrieve rows in the order that they were inserted, you will need some...

If you want to solve the "text output limit" problem then you will first need a specialized split function like this:

ALTER function [dbo].[fnSplit3](

...

Glad I could help (hmm, it does seem like part of my post is missing...).

Glad we could help. 🙂

This is easy enough to do without a cursor:

--======

SET NOCOUNT ON

select N'

----------------------------------------------------------------------------

-- ' + p.name + N'

----------------------------------------------------------------------------

' + m.definition + N'

GO

----------------------------------------------------------------------------

'

from sys.sql_modules m

join sys.procedures p

...

This should work then:

Update c1 set descr = n1.descr

From cit c1

Join nit n1 ON c1.cno=n1.cno

You do not really need sp_xml_preparedocument except for OPENXML, which you do not really need either in SQL 2005.

What you should look at are the XML datatypes and the XML...

psangeetha (9/3/2008)

---

Oh Okay. I thought the select * from table, will always retrieve the rows in the same order. I just tried a select on few tables and it...