SQL Server wire examples
← All examplesFive worked examples against OriginChainDB's TDS listener — the wire protocol used by Microsoft SQL Server. The two connection examples are shown at the driver versions they were actually driven at; the two dialect examples show translation and refusal side by side, because the second one is what decides whether a migration is small or large.
Read the TDS reference first — in particular the T-SQL boundary. The listener is a preview surface, is off unless someone enabled it on your instance, and requires TLS to exist at all.
A complete JDBC connection string, the TLS settings that are not optional, and a first query that returns rows.
The same connection over the Go driver, built from a URL so credentials never land in a hand-concatenated string.
Prepare once, execute many, close the handle - the driver-issued RPC path, and why it is not stored-procedure support.
Bracket identifiers, TOP, OFFSET/FETCH and the scalar-function set, each shown beside the SQL it becomes.
Variables, temp tables, GO, MERGE and date arithmetic - what comes back instead, and the portable rewrite.
Microsoft, SQL Server and T-SQL are trademarks of the Microsoft group of companies; mssql-jdbc and go-mssqldb are Microsoft's own drivers. They are named here only to describe protocol and dialect compatibility and to identify the versions it was measured against. OriginChainDB is not affiliated with, endorsed by, or sponsored by Microsoft, and does not distribute Microsoft software.