MS-TDS T-SQL support

هل هذه الصفحة مفيدة؟

هل لديك ملاحظات إضافية؟

سيتم إرسال الملاحظات إلى Microsoft: بالضغط على الزر «إرسال»، سيتم استخدام ملاحظاتك لتحسين منتجات Microsoft وخدماتها. نهج الخصوصية.

Azure Data Explorer supports a subset of the Microsoft SQL Server communication protocol (MS-TDS), with a subset of the T-SQL query language. Microsoft Excel and Microsoft Power BI are only some of the many tools that can work with Azure Data Explorer. These Microsoft applications also know how to query SQL Server.

Note

Use Azure Active Directory (Azure AD) integrated authentication as the client tool to query Kusto through MS-TDS.

Next steps

• T-SQL - Learn about the T-SQL query language as implemented by Kusto.

• KQL over TDS - Learn about executing native KQL queries via TDS endpoints.

• MS-TDS clients and Kusto - Use Azure Data Explorer from well-known clients that use MS-TDS/T-SQL.

• Azure Data Explorer as linked server to SQL server - Configure the cluster as a linked server to the SQL server on-premises.

• MS-TDS with Azure Active Directory - Use Azure AD via TDS, for connecting to Azure Data Explorer.

• SQL Known Issues - Learn about the main differences between SQL Server's implementation of T-SQL and Azure Data Explorer.