Skip to content

SQL Server T-SQL Parser Support in GSP

Explore the SQL Server T-SQL Parser product page

This page documents the SQL syntax support for Microsoft SQL Server in the General SQL Parser.

Syntax Coverage Corpus

GSP tests SQL Server syntax against 290 documented constructs grouped into 7 categories, each cross-referenced to the documentation that defines it (285 distinct source pages).

Parse coverage

Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the SQL Server documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.

Constructs fully parsed Individual statements parsed
All constructs 290 of 290 (100%) 1082 of 1082 (100%)
SELECT (queries) 29 of 29 (100%) 58 of 58 (100%)
DML (INSERT / UPDATE / DELETE / MERGE) 15 of 15 (100%) 58 of 58 (100%)
Stored procedures 6 of 6 (100%) 7 of 7 (100%)

Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.

Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview

All 290 constructs

Construct Category Parses Specified in
ADD SENSITIVITY CLASSIFICATION all 2 Microsoft docs
ADD SIGNATURE all 1 Microsoft docs
BEGIN CONVERSATION TIMER all 1 Microsoft docs
BEGIN DIALOG CONVERSATION all 2 Microsoft docs
BULK INSERT all 3 Microsoft docs
CLOSE MASTER KEY all 1 Microsoft docs
CLOSE SYMMETRIC KEY all 1 Microsoft docs
COLLATE all 2 Microsoft docs
DELETE all 2 Microsoft docs
DISABLE TRIGGER all 2 Microsoft docs
ENABLE TRIGGER all 1 Microsoft docs
END CONVERSATION all 2 Microsoft docs
EXECUTE AS all 2 Microsoft docs
EXECUTE AS Clause all 1 Microsoft docs
GET CONVERSATION GROUP all 2 Microsoft docs
GET_TRANSMISSION_STATUS all 1 Microsoft docs
INSERT all 2 Microsoft docs
MERGE all 3 Microsoft docs
MOVE CONVERSATION all 4 Microsoft docs
OPEN SYMMETRIC KEY all 1 Microsoft docs
RECEIVE all 3 Microsoft docs
SEND all 6 Microsoft docs
TRUNCATE TABLE all 2 Microsoft docs
UPDATE all 3 Microsoft docs
UPDATE STATISTICS all 6 Microsoft docs
ALTER APPLICATION ROLE ALTER all 2 Microsoft docs
ALTER ASSEMBLY ALTER all 3 Microsoft docs
ALTER ASYMMETRIC KEY ALTER all 4 Microsoft docs
ALTER AUTHORIZATION ALTER all 4 Microsoft docs
ALTER AVAILABILITY GROUP ALTER all 2 Microsoft docs
ALTER BROKER PRIORITY ALTER all 2 Microsoft docs
ALTER CERTIFICATE ALTER all 2 Microsoft docs
ALTER COLUMN ENCRYPTION KEY ALTER all 2 Microsoft docs
ALTER CREDENTIAL ALTER all 2 Microsoft docs
ALTER CRYPTOGRAPHIC PROVIDER ALTER all 3 Microsoft docs
ALTER DATABASE ALTER all 2 Microsoft docs
ALTER DATABASE (Transact-SQL) Compatibility Level ALTER all 2 Microsoft docs
ALTER DATABASE (Transact-SQL) Database Mirroring ALTER all 1 Microsoft docs
ALTER DATABASE (Transact-SQL) File and Filegroup Options ALTER all 2 Microsoft docs
ALTER DATABASE (Transact-SQL) SET HADR ALTER all 1 Microsoft docs
ALTER DATABASE AUDIT SPECIFICATION ALTER all 1 Microsoft docs
ALTER DATABASE ENCRYPTION KEY ALTER all 1 Microsoft docs
ALTER DATABASE SCOPED CONFIGURATION ALTER all 4 Microsoft docs
ALTER DATABASE SET options ALTER all 3 Microsoft docs
ALTER ENDPOINT ALTER all 1 Microsoft docs
ALTER EVENT SESSION ALTER all 2 Microsoft docs
ALTER EXTERNAL DATA SOURCE ALTER all 2 Microsoft docs
ALTER EXTERNAL LANGUAGE ALTER all 1 Microsoft docs
ALTER EXTERNAL LIBRARY ALTER all 2 Microsoft docs
ALTER EXTERNAL RESOURCE POOL ALTER all 1 Microsoft docs
ALTER FULLTEXT CATALOG ALTER all 1 Microsoft docs
ALTER FULLTEXT INDEX ALTER all 2 Microsoft docs
ALTER FULLTEXT STOPLIST ALTER all 2 Microsoft docs
ALTER FUNCTION ALTER all 1 Microsoft docs
ALTER INDEX ALTER all 4 Microsoft docs
ALTER INDEX (Selective XML Indexes) ALTER all 2 Microsoft docs
ALTER LOGIN ALTER all 3 Microsoft docs
ALTER MASTER KEY ALTER all 1 Microsoft docs
ALTER MESSAGE TYPE ALTER all 1 Microsoft docs
ALTER PARTITION FUNCTION ALTER all 5 Microsoft docs
ALTER PARTITION SCHEME ALTER all 1 Microsoft docs
ALTER PROCEDURE ALTER all 4 Microsoft docs
ALTER QUEUE ALTER all 2 Microsoft docs
ALTER REMOTE SERVICE BINDING ALTER all 1 Microsoft docs
ALTER RESOURCE GOVERNOR ALTER all 2 Microsoft docs
ALTER RESOURCE POOL ALTER all 2 Microsoft docs
ALTER ROLE ALTER all 2 Microsoft docs
ALTER ROUTE ALTER all 1 Microsoft docs
ALTER SCHEMA ALTER all 1 Microsoft docs
ALTER SEARCH PROPERTY LIST ALTER all 4 Microsoft docs
ALTER SECURITY POLICY ALTER all 2 Microsoft docs
ALTER SEQUENCE ALTER all 2 Microsoft docs
ALTER SERVER AUDIT ALTER all 6 Microsoft docs
ALTER SERVER AUDIT SPECIFICATION ALTER all 1 Microsoft docs
ALTER SERVER CONFIGURATION ALTER all 3 Microsoft docs
ALTER SERVER ROLE ALTER all 2 Microsoft docs
ALTER SERVICE ALTER all 2 Microsoft docs
ALTER SERVICE MASTER KEY ALTER all 1 Microsoft docs
ALTER SYMMETRIC KEY ALTER all 5 Microsoft docs
ALTER TABLE ALTER all 3 Microsoft docs
ALTER TRIGGER ALTER all 1 Microsoft docs
ALTER USER ALTER all 3 Microsoft docs
ALTER VIEW ALTER all 2 Microsoft docs
ALTER WORKLOAD GROUP ALTER all 4 Microsoft docs
ALTER XML SCHEMA COLLECTION ALTER all 2 Microsoft docs
CREATE AGGREGATE CREATE all 1 Microsoft docs
CREATE APPLICATION ROLE CREATE all 2 Microsoft docs
CREATE ASSEMBLY CREATE all 1 Microsoft docs
CREATE ASYMMETRIC KEY CREATE all 2 Microsoft docs
CREATE AVAILABILITY GROUP CREATE all 1 Microsoft docs
CREATE BROKER PRIORITY CREATE all 3 Microsoft docs
CREATE CERTIFICATE CREATE all 2 Microsoft docs
CREATE COLUMN ENCRYPTION KEY CREATE all 1 Microsoft docs
CREATE COLUMN MASTER KEY CREATE all 2 Microsoft docs
CREATE COLUMNSTORE INDEX CREATE all 2 Microsoft docs
CREATE CONTRACT CREATE all 1 Microsoft docs
CREATE CREDENTIAL CREATE all 1 Microsoft docs
CREATE CRYPTOGRAPHIC PROVIDER CREATE all 1 Microsoft docs
CREATE DATABASE CREATE all 2 Microsoft docs
CREATE DATABASE AUDIT SPECIFICATION CREATE all 1 Microsoft docs
CREATE DATABASE ENCRYPTION KEY CREATE all 1 Microsoft docs
CREATE DATABASE SCOPED CREDENTIAL CREATE all 2 Microsoft docs
CREATE DEFAULT CREATE all 1 Microsoft docs
CREATE ENDPOINT CREATE all 1 Microsoft docs
CREATE EVENT NOTIFICATION CREATE all 1 Microsoft docs
CREATE EVENT SESSION CREATE all 1 Microsoft docs
CREATE EXTERNAL DATA SOURCE CREATE all 1 Microsoft docs
CREATE EXTERNAL FILE FORMAT CREATE all 1 Microsoft docs
CREATE EXTERNAL LANGUAGE CREATE all 2 Microsoft docs
CREATE EXTERNAL LIBRARY CREATE all 2 Microsoft docs
CREATE EXTERNAL RESOURCE POOL CREATE all 1 Microsoft docs
CREATE EXTERNAL TABLE CREATE all 1 Microsoft docs
CREATE FULLTEXT CATALOG CREATE all 1 Microsoft docs
CREATE FULLTEXT INDEX CREATE all 1 Microsoft docs
CREATE FULLTEXT INDEX CREATE all 2 Microsoft docs
CREATE FUNCTION CREATE all 4 Microsoft docs
CREATE INDEX CREATE all 3 Microsoft docs
CREATE LOGIN CREATE all 3 Microsoft docs
CREATE MASTER KEY CREATE all 2 Microsoft docs
CREATE MESSAGE TYPE CREATE all 1 Microsoft docs
CREATE PARTITION FUNCTION CREATE all 3 Microsoft docs
CREATE PARTITION SCHEME CREATE all 3 Microsoft docs
CREATE PROCEDURE CREATE all 4 Microsoft docs
CREATE QUEUE CREATE all 3 Microsoft docs
CREATE REMOTE SERVICE BINDING CREATE all 1 Microsoft docs
CREATE RESOURCE POOL CREATE all 2 Microsoft docs
CREATE ROLE CREATE all 2 Microsoft docs
CREATE ROUTE CREATE all 1 Microsoft docs
CREATE RULE CREATE all 3 Microsoft docs
CREATE SCHEMA CREATE all 2 Microsoft docs
CREATE SEARCH PROPERTY LIST CREATE all 1 Microsoft docs
CREATE SECURITY POLICY CREATE all 1 Microsoft docs
CREATE SELECTIVE XML INDEX CREATE all 1 Microsoft docs
CREATE SEQUENCE CREATE all 1 Microsoft docs
CREATE SERVER AUDIT CREATE all 1 Microsoft docs
CREATE SERVER AUDIT SPECIFICATION CREATE all 1 Microsoft docs
CREATE SERVICE CREATE all 2 Microsoft docs
CREATE SERVICE CREATE all 2 Microsoft docs
CREATE SPATIAL INDEX CREATE all 2 Microsoft docs
CREATE STATISTICS CREATE all 2 Microsoft docs
CREATE SYMMETRIC KEY CREATE all 2 Microsoft docs
CREATE SYNONYM CREATE all 2 Microsoft docs
CREATE TABLE CREATE all 2 Microsoft docs
CREATE TABLE (SQL Graph) CREATE all 2 Microsoft docs
CREATE TABLE (Transact-SQL) IDENTITY (Property) CREATE all 2 Microsoft docs
CREATE TRIGGER (Transact-SQL) CREATE all 2 Microsoft docs
CREATE TYPE CREATE all 2 Microsoft docs
CREATE USER CREATE all 2 Microsoft docs
CREATE VIEW CREATE all 3 Microsoft docs
CREATE XML INDEX CREATE all 1 Microsoft docs
CREATE XML INDEX CREATE all 1 Microsoft docs
CREATE XML INDEX (Selective XML Indexes) CREATE all 1 Microsoft docs
CREATE XML SCHEMA COLLECTION (Transact-SQL) CREATE all 1 Microsoft docs
DROP AGGREGATE DROP all 1 Microsoft docs
DROP APPLICATION ROLE DROP all 1 Microsoft docs
DROP ASSEMBLY DROP all 1 Microsoft docs
DROP ASYMMETRIC KEY DROP all 1 Microsoft docs
DROP AVAILABILITY GROUP DROP all 1 Microsoft docs
DROP BROKER PRIORITY DROP all 1 Microsoft docs
DROP CERTIFICATE DROP all 1 Microsoft docs
DROP COLUMN ENCRYPTION KEY DROP all 1 Microsoft docs
DROP COLUMN MASTER KEY DROP all 1 Microsoft docs
DROP CONTRACT DROP all 1 Microsoft docs
DROP CREDENTIAL DROP all 1 Microsoft docs
DROP CRYPTOGRAPHIC PROVIDER DROP all 1 Microsoft docs
DROP DATABASE DROP all 2 Microsoft docs
DROP DATABASE AUDIT SPECIFICATION DROP all 1 Microsoft docs
DROP DATABASE ENCRYPTION KEY DROP all 1 Microsoft docs
DROP DEFAULT DROP all 1 Microsoft docs
DROP ENDPOINT DROP all 1 Microsoft docs
DROP EVENT NOTIFICATION DROP all 1 Microsoft docs
DROP EVENT SESSION DROP all 1 Microsoft docs
DROP EXTERNAL DATA SOURCE DROP all 1 Microsoft docs
DROP EXTERNAL FILE FORMAT DROP all 1 Microsoft docs
DROP EXTERNAL LANGUAGE DROP all 1 Microsoft docs
DROP EXTERNAL LIBRARY DROP all 1 Microsoft docs
DROP EXTERNAL RESOURCE POOL DROP all 1 Microsoft docs
DROP EXTERNAL TABLE DROP all 3 Microsoft docs
DROP FULLTEXT CATALOG DROP all 1 Microsoft docs
DROP FULLTEXT INDEX DROP all 1 Microsoft docs
DROP FULLTEXT STOPLIST DROP all 1 Microsoft docs
DROP FUNCTION DROP all 1 Microsoft docs
DROP INDEX DROP all 2 Microsoft docs
DROP INDEX (Selective XML Indexes) DROP all 1 Microsoft docs
DROP LOGIN DROP all 1 Microsoft docs
DROP MASTER KEY DROP all 1 Microsoft docs
DROP MESSAGE TYPE DROP all 1 Microsoft docs
DROP PARTITION FUNCTION DROP all 1 Microsoft docs
DROP PARTITION SCHEME DROP all 1 Microsoft docs
DROP PROCEDURE DROP all 1 Microsoft docs
DROP QUEUE DROP all 1 Microsoft docs
DROP REMOTE SERVICE BINDING DROP all 1 Microsoft docs
DROP RESOURCE POOL DROP all 1 Microsoft docs
DROP ROLE DROP all 1 Microsoft docs
DROP ROUTE DROP all 1 Microsoft docs
DROP RULE DROP all 1 Microsoft docs
DROP SCHEMA DROP all 1 Microsoft docs
DROP SEARCH PROPERTY LIST DROP all 1 Microsoft docs
DROP SECURITY POLICY DROP all 1 Microsoft docs
DROP SENSITIVITY CLASSIFICATION DROP all 1 Microsoft docs
DROP SEQUENCE DROP all 1 Microsoft docs
DROP SERVER AUDIT DROP all 1 Microsoft docs
DROP SERVER AUDIT SPECIFICATION DROP all 1 Microsoft docs
DROP SERVER ROLE DROP all 1 Microsoft docs
DROP SERVICE DROP all 1 Microsoft docs
DROP SIGNATURE DROP all 1 Microsoft docs
DROP STATISTICS DROP all 2 Microsoft docs
DROP SYMMETRIC KEY DROP all 1 Microsoft docs
DROP SYNONYM DROP all 1 Microsoft docs
DROP TABLE DROP all 1 Microsoft docs
DROP TRIGGER DROP all 1 Microsoft docs
DROP TYPE DROP all 1 Microsoft docs
DROP USER DROP all 1 Microsoft docs
DROP VIEW DROP all 1 Microsoft docs
DROP WORKLOAD GROUP DROP all 1 Microsoft docs
DROP XML SCHEMA COLLECTION DROP all 1 Microsoft docs
INSERT (SQL Graph) INSERT all 3 Microsoft docs
DENY Availability Group Permissions Permissions all 3 Microsoft docs
DENY Database Permissions Permissions all 3 Microsoft docs
DENY Database Principal Permissions Permissions all 3 Microsoft docs
DENY Endpoint Permissions Permissions all 3 Microsoft docs
DENY Object Permissions Permissions all 2 Microsoft docs
DENY Server Permissions Permissions all 3 Microsoft docs
DENY Server Principal Permissions Permissions all 3 Microsoft docs
DENY Symmetric Key Permissions Permissions all 3 Microsoft docs
DENY System Object Permissions Permissions all 2 Microsoft docs
DENY Type Permissions Permissions all 2 Microsoft docs
DENY XML Schema Collection Permissions Permissions all 3 Microsoft docs
GRANT Permissions all 4 Microsoft docs
GRANT Availability Group Permissions Permissions all 3 Microsoft docs
GRANT Database Permissions Permissions all 3 Microsoft docs
GRANT Database Principal Permissions Permissions all 2 Microsoft docs
GRANT Endpoint Permissions Permissions all 3 Microsoft docs
GRANT Full-Text Permissions Permissions all 1 Microsoft docs
GRANT Object Permissions Permissions all 3 Microsoft docs
GRANT Schema Permissions Permissions all 1 Microsoft docs
GRANT Search Property List Permissions Permissions all 1 Microsoft docs
GRANT Server Permissions Permissions all 6 Microsoft docs
GRANT Server Principal Permissions Permissions all 3 Microsoft docs
GRANT Symmetric Key Permissions Permissions all 3 Microsoft docs
GRANT System Object Permissions Permissions all 4 Microsoft docs
GRANT Type Permissions Permissions all 2 Microsoft docs
GRANT XML Schema Collection Permissions Permissions all 3 Microsoft docs
OPEN MASTER KEY Permissions all 1 Microsoft docs
REVERT Permissions all 1 Microsoft docs
REVOKE Availability Group Permissions Permissions all 5 Microsoft docs
REVOKE Database Permissions Permissions all 3 Microsoft docs
REVOKE Database Principal Permissions Permissions all 3 Microsoft docs
REVOKE Endpoint Permissions Permissions all 3 Microsoft docs
REVOKE Object Permissions Permissions all 3 Microsoft docs
REVOKE Server Permissions Permissions all 3 Microsoft docs
REVOKE Server Principal Permissions Permissions all 3 Microsoft docs
REVOKE Symmetric Key Permissions Permissions all 3 Microsoft docs
REVOKE System Object Permissions Permissions all 2 Microsoft docs
REVOKE Type Permissions Permissions all 2 Microsoft docs
REVOKE XML Schema Collection Permissions Permissions all 3 Microsoft docs
SETUSER Permissions all 5 Microsoft docs
SET ANSI_DEFAULTS SET all 6 Microsoft docs
SET ANSI_NULL_DFLT_OFF SET all 40 Microsoft docs
SET ANSI_NULL_DFLT_ON SET all 41 Microsoft docs
SET ANSI_NULLS SET all 10 Microsoft docs
SET ANSI_PADDING SET all 11 Microsoft docs
SET ANSI_WARNINGS SET all 19 Microsoft docs
SET ARITHABORT SET all 51 Microsoft docs
SET ARITHIGNORE SET all 3 Microsoft docs
SET CONCAT_NULL_YIELDS_NULL SET all 10 Microsoft docs
SET CONTEXT_INFO SET all 5 Microsoft docs
SET CURSOR_CLOSE_ON_COMMIT SET all 39 Microsoft docs
SET DATEFIRST SET all 5 Microsoft docs
SET DATEFORMAT SET all 11 Microsoft docs
SET DEADLOCK_PRIORITY SET all 4 Microsoft docs
SET FMTONLY SET all 23 Microsoft docs
SET FORCEPLAN SET all 22 Microsoft docs
SET IDENTITY_INSERT SET all 20 Microsoft docs
SET IMPLICIT_TRANSACTIONS SET all 69 Microsoft docs
SET LANGUAGE SET all 7 Microsoft docs
SET LOCK_TIMEOUT SET all 2 Microsoft docs
SET NOCOUNT SET all 12 Microsoft docs
SET NOEXEC SET all 26 Microsoft docs
SET NUMERIC_ROUNDABORT SET all 45 Microsoft docs
SET QUOTED_IDENTIFIER SET all 14 Microsoft docs
SET ROWCOUNT SET all 4 Microsoft docs
SET SHOWPLAN_ALL SET all 10 Microsoft docs
SET SHOWPLAN_TEXT SET all 8 Microsoft docs
SET SHOWPLAN_XML SET all 9 Microsoft docs
SET STATISTICS IO SET all 8 Microsoft docs
SET STATISTICS TIME SET all 8 Microsoft docs
SET STATISTICS XML SET all 10 Microsoft docs
SET TRANSACTION ISOLATION LEVEL SET all 12 Microsoft docs
SET XACT_ABORT SET all 30 Microsoft docs

Key Features Supported

  • Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
  • T-SQL specific syntax and functions
  • Stored procedures and user-defined functions
  • Common table expressions (CTEs)
  • Window functions and analytical queries
  • XML and JSON data handling