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.


In this topic:

Must read

News:

1 - 2 of 2

VIEW ALL News ON SQL-Transact SQL (T-SQL)

Reference & Learning:

1 - 3 of 42
  • Top 10 SQL Server development tips of 2008 07 Jan 2009

    The Year in Review - 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...

  • Supertype and subtype tables in SQL Server 16 Sep 2008

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

  • SQL Server and data manipulation in T-SQL 16 Sep 2008

    Book Excerpt - 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 and...

VIEW ALL Reference & Learning ON SQL-Transact SQL (T-SQL)

Expert Technical Advice:

1 - 3 of 117

VIEW ALL Expert Technical Advice ON SQL-Transact SQL (T-SQL)

Definitions:

1 - 3 of 10

VIEW ALL Definitions ON SQL-Transact SQL (T-SQL)