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...
-- 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
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
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 |
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 |
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 |