Languages Features Creators CSV Resources Challenges Add Language
GitHub icon

Transact-SQL

Transact-SQL - Query language

< >

Transact-SQL is a query language created in 1984.

#382on PLDB 39Years Old 1.5kUsers
8Books 0Papers

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements. Read more on Wikipedia...


Example from Wikipedia:
-- begin transaction BEGIN TRAN BEGIN TRY -- execute each statement INSERT INTO MYTABLE(NAME) VALUES ('ABC') INSERT INTO MYTABLE(NAME) VALUES ('123') -- commit the transaction COMMIT TRAN END TRY BEGIN CATCH -- roll back the transaction because of error ROLLBACK TRAN END CATCH

Keywords in Transact-SQL

ABSOLUTE ACTION ADA ADD ADMIN AFTER AGGREGATE ALIAS ALL ALLOCATE ALTER AND ANY ARE ARRAY AS ASC ASENSITIVE ASSERTION ASYMMETRIC AT ATOMIC AUTHORIZATION AVG BACKUP BEFORE BEGIN BETWEEN BINARY BIT BITLENGTH BLOB BOOLEAN BOTH BREADTH BREAK BROWSE BULK BY CALL CALLED CARDINALITY CASCADE CASCADED CASE CAST CATALOG CHAR CHARLENGTH CHARACTER CHARACTERLENGTH CHECK CHECKPOINT CLASS CLOB CLOSE CLUSTERED COALESCE COLLATE COLLATION COLLECT COLUMN COMMIT COMPLETION COMPUTE CONDITION CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONSTRUCTOR CONTAINS CONTAINSTABLE CONTINUE CONVERT CORR CORRESPONDING COUNT COVARPOP COVARSAMP CREATE CROSS CUBE CUMEDIST CURRENT CURRENTCATALOG CURRENTDATE CURRENTDEFAULTTRANSFORMGROUP CURRENTPATH CURRENTROLE CURRENTSCHEMA CURRENTTIME CURRENTTIMESTAMP CURRENTTRANSFORMGROUPFORTYPE CURRENTUSER CURSOR CYCLE DATA DATABASE DATE DAY DBCC DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DENY DEPTH DEREF DESC DESCRIBE DESCRIPTOR DESTROY DESTRUCTOR DETERMINISTIC DIAGNOSTICS DICTIONARY DISCONNECT DISK DISTINCT DISTRIBUTED DOMAIN DOUBLE DROP DUMP DYNAMIC EACH ELEMENT ELSE END END-EXEC EQUALS ERRLVL ESCAPE EVERY EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXIT EXTERNAL EXTRACT FALSE FETCH FILE FILLFACTOR FILTER FIRST FLOAT FOR FOREIGN FORTRAN FOUND FREE FREETEXT FREETEXTTABLE FROM FULL FULLTEXTTABLE FUNCTION FUSION GENERAL GET GLOBAL GO GOTO GRANT GROUP GROUPING HAVING HOLD HOLDLOCK HOST HOUR IDENTITY IDENTITYINSERT IDENTITYCOL IF IGNORE IMMEDIATE IN INCLUDE INDEX INDICATOR INITIALIZE INITIALLY INNER INOUT INPUT INSENSITIVE INSERT INT INTEGER INTERSECT INTERSECTION INTERVAL INTO IS ISOLATION ITERATE JOIN KEY KILL LANGUAGE LARGE LAST LATERAL LEADING LEFT LESS LEVEL LIKE LIKEREGEX LIMIT LINENO LN LOAD LOCAL LOCALTIME LOCALTIMESTAMP LOCATOR LOWER MAP MATCH MAX MEMBER MERGE METHOD MIN MINUTE MOD MODIFIES MODIFY MODULE MONTH MULTISET NAMES NATIONAL NATURAL NCHAR NCLOB NEW NEXT NO NOCHECK NONCLUSTERED NONE NORMALIZE NOT NULL NULLIF NUMERIC OBJECT OCCURRENCESREGEX OCTETLENGTH OF OFF OFFSETS OLD ON ONLY OPEN OPENDATASOURCE OPENQUERY OPENROWSET OPENXML OPERATION OPTION OR ORDER ORDINALITY OUT OUTER OUTPUT OVER OVERLAPS OVERLAY PAD PARAMETER PARAMETERS PARTIAL PARTITION PASCAL PATH PERCENT PERCENTRANK PERCENTILECONT PERCENTILEDISC PIVOT PLAN POSITION POSITIONREGEX POSTFIX PRECISION PREFIX PREORDER PREPARE PRESERVE PRIMARY PRINT PRIOR PRIVILEGES PROC PROCEDURE PUBLIC RAISERROR RANGE READ READS READTEXT REAL RECONFIGURE RECURSIVE REF REFERENCES REFERENCING REGRAVGX REGRAVGY REGRCOUNT REGRINTERCEPT REGRR2 REGRSLOPE REGRSXX REGRSXY REGRSYY RELATIVE RELEASE REPLICATION RESTORE RESTRICT RESULT RETURN RETURNS REVERT REVOKE RIGHT ROLE ROLLBACK ROLLUP ROUTINE ROW ROWCOUNT ROWGUIDCOL ROWS RULE SAVE SAVEPOINT SCHEMA SCOPE SCROLL SEARCH SECOND SECTION SECURITYAUDIT SELECT SEMANTICKEYPHRASETABLE SEMANTICSIMILARITYDETAILSTABLE SEMANTICSIMILARITYTABLE SENSITIVE SEQUENCE SESSION SESSIONUSER SET SETS SETUSER SHUTDOWN SIMILAR SIZE SMALLINT SOME SPACE SPECIFIC SPECIFICTYPE SQL SQLCA SQLCODE SQLERROR SQLEXCEPTION SQLSTATE SQLWARNING START STATE STATEMENT STATIC STATISTICS STDDEVPOP STDDEVSAMP STRUCTURE SUBMULTISET SUBSTRING SUBSTRINGREGEX SUM SYMMETRIC SYSTEM SYSTEMUSER TABLE TABLESAMPLE TEMPORARY TERMINATE TEXTSIZE THAN THEN TIME TIMESTAMP TIMEZONEHOUR TIMEZONEMINUTE TO TOP TRAILING TRAN TRANSACTION TRANSLATE TRANSLATEREGEX TRANSLATION TREAT TRIGGER TRIM TRUE TRUNCATE TRYCONVERT TSEQUAL UESCAPE UNDER UNION UNIQUE UNKNOWN UNNEST UNPIVOT UPDATE UPDATETEXT UPPER USAGE USE USER USING VALUE VALUES VARPOP VARSAMP VARCHAR VARIABLE VARYING VIEW WAITFOR WHEN WHENEVER WHERE WHILE WIDTHBUCKET WINDOW WITH WITHIN WITHIN GROUP WITHOUT WORK WRITE WRITETEXT XMLAGG XMLATTRIBUTES XMLBINARY XMLCAST XMLCOMMENT XMLCONCAT XMLDOCUMENT XMLELEMENT XMLEXISTS XMLFOREST XMLITERATE XMLNAMESPACES XMLPARSE XMLPI XMLQUERY XMLSERIALIZE XMLTABLE XMLTEXT XMLVALIDATE YEAR ZONE

Language features

Feature Supported Token Example
MultiLine Comments ✓
Integers ✓
-- [0-9]+
Floats ✓
-- [0-9]+\.[0-9]*(e[+-]?[0-9]+)?
Hexadecimals ✓
-- 0x[0-9a-f]+
Booleans ✓ TRUE FALSE
Comments ✓
-- A comment
Line Comments ✓ --
-- A comment
Semantic Indentation X

Books about Transact-SQL on goodreads

title author year reviews ratings rating
Transact-SQL Programming Kevin E. Kline 2001 0 2 3.00
Transact-SQL (IDG Professional Programming) William C. Amo 1998 0 3 2.67
Optimizing Transact-SQL: Advanced Programming Techniques David Rozenshtein 1997 0 3 4.33
Transact-SQL Programming Black Book [With CDROM] Paul Whitehead 0 0 0.0

Books about Transact-SQL from ISBNdb

title authors year publisher
Beginning Transact-SQL with SQL Server 2000 and 2005 Turley, Paul 2005 Wrox
Exam Ref 70-761 Querying Data with Transact-SQL Ben-Gan, Itzik 2017 Microsoft Press
Transact-SQL Cookbook: Help for Database Programmers Spetic, Ales and Gennick, Jonathan 2002 O'Reilly Media
Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 Kline, Kevin and Gould, Lee and Zanevsky, Andrew 1999 O'Reilly Media
xbasepp.html · transact-sql.html · chrysalisp.html

View source

- Build the next great programming language · Search · Day 213 · About · Blog · Acknowledgements · Traffic · Traffic Today · GitHub · feedback@pldb.com