How to read XML file from SQL Server. The OPENXML statement and a little bit of Datascience
Hi Guys, Welcome back! Would you like to learn how to read XML file from SQL Server ? Would you like to learn how to use the OPENXML statement ? Today we will do also some datascience. So what are you waiting for? … Follow me! Introduction XML files are very popular nowadays. They are nothing more than text files with a structure established by means of tags . An example of an XML file could be this: < ROOT > < ROW STAZIONE = "san pietro capofiume " DATAINIZIO = "31/12/2018 23.00.00" DATAFINE = "01/01/2019" STRUMENTO = "api 200e" NO2 = "28" UM = " ug /m3" F1 = "" F2 = "1" ...