Veja um exemplo de como recuperar informações de funcionários em um banco de dados como XML usando uma consulta com FOR XML EXPLICIT.
Set rstTitlesPublishers = New ADODB.Recordset strSQL = "SELECT title_ID AS TitleID, title AS Title, " & _ "publishers.pub_id AS PubID, pub_name AS PubName " & _ "FROM publishers INNER JOIN Titles " & _ "ON publishers.pub_id = Titles.pub_id " & _ "ORDER BY Title" rstTitles...
ORDER BY PassengerCount /*** What is the distribution of trips by hour on working days (non-holiday weekdays)? ***/ SELECT ti.HourlyBucket, COUNT(*) AS CountOfTrips FROM dbo.Trip AS tr INNER JOIN dbo.Date AS d ON tr.DateID = d.DateID INNER JOIN dbo.Time AS ti ON tr.Pickup...
Set rstTitlesPublishers = New ADODB.Recordset strSQL = "SELECT title_ID AS TitleID, title AS Title, " & _ "publishers.pub_id AS PubID, pub_name AS PubName " & _ "FROM publishers INNER JOIN Titles " & _ "ON publishers.pub_id = Titles.pub_id " & _ "ORDER BY Title" rstTitles...