View all newsletters
Receive our newsletter - data, insights and analysis delivered to you
  1. What Is
April 3, 2017updated 27 Oct 2023 9:21am

What is T-SQL?

Find out why this extension is used by Sybase and Microsoft.

By James Nunns

T-SQL, short for Transact-SQL, is not one thing but a set of programming extensions for Sybase and Microsoft.

The programming extensions basically act as as extension to Structured Query Language, SQL is designed to allow users to interact with relational databases.

T-SQL is regarded as an extension of SQL since it comes with additional features such as; procedural programming, local variables/error handling and data processing.

What is essential for T-SQL?

The procedural programming extension enables users to understand a series of computational steps that will be carried out.

Local Variables are essential for tracking any unknown quantities that need to be assessed, and are an important expansion that T-SQL provides.

T-SQL is in essence a secondary way of programming and managing SQL Server. It does this by exposing keywords for the operations that can be performed on SQL Server.

For example, creating and altering database schemas, entering and editing data in the database as well as monitoring.

Content from our partners
Rethinking cloud: challenging assumptions, learning lessons
DTX Manchester welcomes leading tech talent from across the region and beyond
The hidden complexities of deploying AI in your business

Websites in our network
Select and enter your corporate email address Tech Monitor's research, insight and analysis examines the frontiers of digital transformation to help tech leaders navigate the future. Our Changelog newsletter delivers our best work to your inbox every week.
  • CIO
  • CTO
  • CISO
  • CSO
  • CFO
  • CDO
  • CEO
  • Architect Founder
  • MD
  • Director
  • Manager
  • Other
Visit our privacy policy for more information about our services, how Progressive Media Investments may use, process and share your personal data, including information on your rights in respect of your personal data and how you can unsubscribe from future marketing communications. Our services are intended for corporate subscribers and you warrant that the email address submitted is your corporate email address.