We can convert the relational data stored in the table into XML by using the FOR XML syntax, I am not going to the explain all the features of FOR XML. Physical table SELECT * FROM ASPNET_Roles FOR XML AUTO , ROOT ( 'A' ), ELEMENTS this select statement will give the following output < A > < URR_ASPNET_Roles > < ApplicationId > AFFE3DDD-ABAD-49DF-A144-DA87BE69B90E </ ApplicationId > < RoleId > 89C306A6-2D21-42AB-A42F-5029091CB4E8 </ RoleId > < RoleName > SBU User </ RoleName > < LoweredRoleName > sbu user </ LoweredRoleName > < USER_TYPE > 2 </ USER_TYPE > </ URR_ASPNET_Roles > < URR_ASPNET_Roles > < ApplicationId > AFFE3DDD-ABAD-49DF-A144-DA87BE69B90E </ ApplicationId > < RoleId > 180BA05D-D2A5-49CA-BED3-3C6F080F6543 </ RoleId > < RoleName > Super User </ RoleName > < LoweredRoleName > super user </ LoweredRoleName > < USER_TYPE
The practical "bytes" of Agile And DevOps Transformation