Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Openxml()
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Openxml()
Divers
Thread ID:
00864550
Message ID:
00864550
Vues:
62
Hello,

I am playing with the OPENXML() Command and am pretty successfull with the examples. But one thing I wasen't able to figure out yet:
DECLARE @idoc int
DECLARE @doc varchar(8000)
set @doc = '<ROOT>
	<row CustomerID="ALFKI" CompanyName="Alfreds Futterkiste" ContactName="Maria Anders" Country="Germany" />
</ROOT>'
...
How can I use a XML File out of the FileSystem instead of defining the XML File in the Stored Procedure?

Marcus
Marcus Alt
TRIA IT-Consulting GmbH
Working hard | for your success
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform