Skip to content

Latest commit

 

History

History
23 lines (18 loc) · 1.09 KB

adodotnet-query.md

File metadata and controls

23 lines (18 loc) · 1.09 KB
title ms.date ms.service ms.reviewer ms.topic author ms.author
AdoDotNet.Query | Microsoft Docs
4/16/2018
powerquery
gepopell
reference
dougklopfenstein
bezhan

AdoDotNet.Query

Syntax

  
AdoDotNet.Query(providerName as text, connectionString as any, query as text, optional options as nullable record) as table

About

Returns the result of running query with the connection string connectionString using the ADO.NET provider providerName. connectionString can be text or a record of property value pairs. Property values can either be text or number. An optional record parameter, options, may be provided to specify additional properties. The record can contain the following fields:

  • CommandTimeout : A duration which controls how long the server-side query is allowed to run before it is canceled. The default value is ten minutes.
  • SqlCompatibleWindowsAuth : A logical (true/false) that determines whether to produce SQL Server-compatible connection string options for Windows authentication. The default value is true.