Are you trying to save the OUTPUT of a FOR XML query (XML result document) to a file?

You might require an XSD, either as a separate file or embedded into the XML document. Could you post a sample XML document?

could you show a sample xml document and the output you are looking for? why do you need a table or table variable with a specific name?

Physical tables are USUALLY created to store the application data. They store all the persistent data that your application needs.

Temporary tables are used to store temporary information. Most of...

I am not clear about what exactly you expect from SQL Server to do here. If you are combining the data of different organizations into a single database, your tables...

It looks to me that a transactional...

Swirl80 (1/24/2009)

---

thanks for the reply. If that is the case then why is there the "Sparse" column feature in 2008? If NULL takes up not space at all then surely...

SQL Server uses a NULL bitmap to indicate which columns are NULL. So when the value is NULL, SQL Sever does not really need to store anything, instead just set...

Storing NULL value does not take any additional storage space.

Storage of a value in a variable length column (VARCHAR/NVARCHAR etc) takes the number of bytes needed to store...

In addition to what Gail said,

are you sure that you are taking TRN LOG backups? Or just database backups only?

You might need to take a transaction log backup,...

This might help.

select

p.name,

t.name,

p.max_length

from sys.parameters p

inner join sys.types t on p.system_type_id = p.system_type_id

where object_id = object_id('your-procedure')

What file (data or log) are you trying to shrink?

What SQL command did you use to shrink the files?

[note: shrinking a production database is usually a bad idea, unless you...

Here is on option:

DECLARE @x XML

SELECT @x = '

[Appointment]

[Date]1/14/2008[/Date]

[/Appointment]'

DECLARE @d VARCHAR(10)

SELECT @d = CONVERT( VARCHAR,

DATEADD(year, 1, @x.value('(Appointment/Date)[1]','DATETIME')),

101)

SET @x.modify('

replace value of (Appointment/Date/text())[1]

with sql:variable("@d")

')

SELECT @x

/*

[Appointment]

...

You cannot use replace the node with a variable. Instead, you can achieve the same results using the following query:

the following example shows how to use variables in an XPATH...

This will do

Note that I have replaced XML tags with []

DECLARE @x XML

SELECT @x = '

[SQLRuleSet

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:xsd="http://www.w3.org/2001/XMLSchema"]

[SQLRule rulename="CEMPID" ruletype="SQLText" comment="" DB="SIEBEL" enable="1"]

[simpletext]select top(100)...