We can generate xml schema of any table data in sql server in a very easy way.
for this sql server has provided XML PATH keyword.
after executing this you will get result in result window something like that
for this sql server has provided XML PATH keyword.
after executing this you will get result in result window something like that
after clicking on blue content you can see that our XML has been generated.
