0
Good night I’m starting in the career of developer and I’m creating an application that will read an xml file.
I am having difficulty passing a command in the sql database that returns all tables and their attributes ( column and values).
Thank you
0
Good, look at this example:
SELECT *
FROM dbo.YourStudentTable
FOR XML PATH('Student'), ROOT ('Students')
drawn from https://stackoverflow.com/questions/18654157/how-to-make-sql-query-result-to-xml-file
Browser other questions tagged sql sql-server mvc
You are not signed in. Login or sign up in order to post.
What is the relationship between reading XML file and getting the list of tables and columns?
– José Diz
in charge:
SELECT * FROM INFORMATION_SCHEMA.Columnsthere should be all tables and columns– Rovann Linhalis
the idea is to transform a query in the sql server database into an xml file. I am using the following command: use Automacaotest SELECT * FROM INFORMATION_SCHEMA.Columns for xml path the idea was to get close to something : <Tablename> <ID>1</ID> <Description>Browser Google Chrome</Description> <Operation>1</Operation> <Massadados>1</Massadados> </Nometabela> <Nometabela> <ID>1</ID> <Descricao>Browser Google Chrome</Descricao> <Operation>1</Operation> <Massadados>1</Massadados> </Nometabela>
– Jaderson Pessoa
didn’t understand a thing. vc want to generate in sql an xml containing all tables and their values?
– fnightangel
that , generate an xml containing all tables and values in sql , so q o SELECT * FROM INFORMATION_SCHEMA.Columns shows only columns without their values
– Jaderson Pessoa