TDS is the protocol used by Microsoft SQL Server, a popular relational database management system. Due to its prevalence, many applications allow connection to SQL Server via the TDS protocol. This section covers examples of connection to the TDS-implemented Connect Virtual SQL Server endpoint, metadata discovery and supported queries.

Connecting to Virtual SQL Server

There are many libraries and application that allow you to connect to SQL Databases. See Connecting to Virtual SQL Server for examples on how to connect to the Connect Virtual SQL Server endpoint from various tools and applications

Schema Discovery

Before running any SQL queries against a connection, you will need to know what resources are available. See Schema Discovery for information on how to discover what tables, views and procedures are available through the Connect Virtual SQL Server endpoint.

Query Syntax

SQL syntax allows for a variety of filtering and formatting options to retrieve data, as well as data-manipulation functionality. See Query Syntax for examples of what queries are supported in the Connect Virtual SQL Server endpoint.