SQL-Transact SQL (T-SQL)
T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables. See complete definition.
New & Notable
SQL-Transact SQL (T-SQL) News
-
September 30, 2016
30
Sep'16
Azure Data Lake Analytics gets boost from U-SQL, a new SQL variant
The big data movement has frozen out many data professionals who are versed in SQL. Microsoft's U-SQL programming language tries to get such folks back in the data querying game.
-
July 09, 2015
09
Jul'15
Limited public preview opens for Azure SQL Data Warehouse
Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.
SQL-Transact SQL (T-SQL) Get Started
Bring yourself up to speed with our introductory content
-
SQL (Structured Query Language)
SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them. Continue Reading
-
T-SQL (Transact-SQL)
T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables. Continue Reading
-
Microsoft SQL Server
Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments Continue Reading
Evaluate SQL-Transact SQL (T-SQL) Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
Microsoft SQL Server 2016: Previews show promise for next year
Microsoft SQL Server 2016 will be released next year. But in 2015, we've already had a glimpse into improved in-memory OLTP, security features, analytics and Stretch Database. Continue Reading
-
How to get started with PolyBase in SQL Server 2016
With PolyBase, when you use SQL Server 2016 as your data source, you have easy access to Hadoop and Azure Blob Storage data from whatever environment you're working in. Continue Reading
-
Comparing memory-optimized tables and disk-based tables
In all tests performed by expert Basit Farooq, memory-optimized tables outperformed disk-based tables by running faster and generating less disk I/O. Continue Reading
Manage SQL-Transact SQL (T-SQL)
Learn to apply best practices and optimize your operations.
-
Using SQL DATEPART, GETDATE, DATENAME functions
SQL datetime functions DATEPART, GETDATE and DATENAME can retrieve the date and time or other individual parts of a value. Here's how to master these T-SQL tools. Continue Reading
-
Configure SQL Server at database level with new scoping syntax
SQL Server 2016 adds ALTER DATABASE SCOPED CONFIGURATION to its new T-SQL statements. The statement lets DBAs control database configuration at the level of a single database. Continue Reading
-
SQL Server best practices for handling the post-installation blues
The job isn't over after a successful SQL Server installation. These SQL Server best practices will help you optimize your new SQL Server installation from the start. Continue Reading
Problem Solve SQL-Transact SQL (T-SQL) Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
-
What's the difference between DDL and DML?
What's the difference between DDL and DML? Get the answer and see examples of data manipulation language and data definition language commands for SQL databases. Continue Reading
-
DATEADD and DATEDIFF SQL functions for datetime values
DATEADD and DATEDIFF SQL functions allow you to easily perform calculations, like adding a time interval from a datetime value. Here's how to use those functions for that and more. Continue Reading
-
Troubleshoot SQL Server database performance with T-SQL
Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications. Continue Reading