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...
Após concluir o carregamento de dados de exemplo, o Warehouse exibe os dados carregados nas tabelas e exibições para consulta.Scripts de exemploSeu novo warehouse está pronto para aceitar consultas T-SQL. Os scripts T-SQL de amostra a seguir podem ser usados nos dados de amostra em...
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...
// Latest scorecard results for a given feature // set the feature flag name to query let QueryFeature = "MyFeatureFlag"; AEWExperimentAssignmentSummary | where FeatureName == QueryFeature | summarize arg_max(MaxTimeGenerated, AllocationId) | join kind=inner AEWExperimentScorecards on Alloca...