Featured
-
Find out a particular column throughout the database in Postgresql
Previously got a situation where I needed to get t
by Nitika.Verma
Tags
Creating xml from SQL query
This blog will show you how to create an xml from sql query having sql data. Write down the followng query to generate xml:-
WITH XMLNAMESPACES ('http://www.dossia.org/v2.0/xml/phr' as phr)
Select OrderResultID,OrderID ,PatientID ,SpecimenNum...
SQL - Generating XML 2
Every XML has two elements i.e.
1) Attributes and
2) Value
SELECT magazineId AS '@id'
, magazineName AS '@name'
, CoverPage AS '@coverPage'
, isActive AS '@status'
, publishDate AS '@publishDate'
, expiryDate A...