Good evening I'm starting in the career of developer and I'm creating an application that le an xml file.
I'm having trouble passing a command in sql database that returns all tables and their attributes (column and values).
Thank you
Good evening I'm starting in the career of developer and I'm creating an application that le an xml file.
I'm having trouble passing a command in sql database that returns all tables and their attributes (column and values).
Thank you
Well, look at this example:
SELECT *
FROM dbo.YourStudentTable
FOR XML PATH('Student'), ROOT ('Students')
taken from link