SQL-Transact SQL (T-SQL)

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • The most dangerous game: Hunting down bad SQL query performance

    SQL Server is faster when the queries behind your applications are faster. Learn how to spot bad SQL query performance, and then work with developers so you can improve throughput.  Feature

  • Top 10 SQL Server development tips of 2008

    Here are the top 10 most viewed SQL Server development tips of 2008. From converting date/time values into character types, working with DATETIME and SMALLDATETIME in SQL Server 2005, using a stored procedure to find the size of SQL Server tables and...  The Year in Review

  • Supertype and subtype tables in SQL Server

    Learn how to physically implement supertype and subtype tables and clusters on a SQL Server in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones.  Book Excerpt

  • SQL Server and data manipulation in T-SQL

    Learn about stored procedures, parameters, triggers and how other T-SQL code functions allow for the manipulation of data in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson an...  Book Excerpt

  • Top 10 SQL Server development questions

    Development in SQL Server can put you in a crunch and seeking for a quick solution. We've compiled a Top 10 list of your frequently asked questions when it comes to SQL Server development. In this quick reference you'll get solutions to combat proble...  FAQ

  • FAQ: Creating and altering SQL Server tables

    Whether you want to select rows, move records, track activity or perform various other table-related tasks, this collection of frequently asked questions offers expert insights to help.  FAQ

  • FAQ: SQL Server stored procedure how-tos

    Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines.  FAQ

  • Top 10 T-SQL tips for improved SQL Server development

    Having difficult with your T-SQL programming extensions or simply want to make improvements within your SQL Server development? We've compiled a Top 10 list of the most popular tips your peers are reading. Find out how to script SQL Server backups, w...  Top Expert Tips

  • How to use SQL Trace definition

    Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace, from how to use trace definition through incorporati...  Step-by-Step Guide

  • Script example for SQL Trace

    Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace, from how to use trace definition through incorporati...  Step-by-Step Guide

  • See More: Essential Knowledge on SQL-Transact SQL (T-SQL)

  • ACID (atomicity, consistency, isolation, and durability)

    ACID (atomicity, consistency, isolation, and durability) is an acronym and mnemonic device for learning and remembering the four primary attributes ensured to any transaction by a transaction manager (which is also called a transaction monitor).  Definition

  • OLE DB (OLEDB or Object Linking and Embedding Database)

    OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources.  Definition

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

  • SQL (Structured Query Language)

    SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database.  Definition

  • commit

    A commit is the final step in the successful completion of a previously started database change as part of handling a transaction in a computing system.  Definition

  • Collaboration Data Objects (CDO)

    Collaboration Data Objects (CDO) is Microsoft's technology for building messaging or collaboration applications or adding these capabilities to existing applications.  Definition

  • container

    In Sun Microsystems' JavaBeans component architecture and in Microsoft's Component Object Model (COM), a container is an application program or subsystem in which the program building block known as a component is run.  Definition

  • DAO (Data Access Objects)

    DAO (Data Access Objects) is an application program interface (API) available with Microsoft's Visual Basic that lets a programmer request access to a Microsoft Access database.  Definition

  • fetch

    In computer technology, fetch has several meanings related to getting, reading, or moving data objects.  Definition

  • query

    A database query can be either a select query or an action query. A select query is simply a data retrieval query. An action query can ask for additional operations on the data, such as insertion, updating or deletion.  Definition

About SQL-Transact SQL (T-SQL)

Transact SQL, often called T-SQL, is Microsoft's implementation of the SQL language. Developers for SQL Server database management systems are using T-SQL statements for any application communicating with an instance of SQL Server does so by sending Transact SQL statements to the server. Improve your T-SQL skills with these T-SQL overviews, best practices and stored procedures. In this reference, find out how to script SQL Server backups, why T-SQL in SSIS has pros and cons and what to do about poorly written T-SQL code that's causing SQL Server performance problems.