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.
T-SQL
SQL-Transact SQL (T-SQL) News
-
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.
-
May 13, 2005
13
May'05
Step 3: Consider using implicit transactions
Get up to speed on server-level options to add another layer of integrity protection.
SQL-Transact SQL (T-SQL) Get Started
Bring yourself up to speed with our introductory content
-
SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT
In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here. Continue Reading
-
How to create a SQL inner join and outer join: Basics to get started
When you're querying a SQL Server database and want to pull related data from more than one table, you'll need to create a join, and here's how. Continue Reading
-
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 ... Continue Reading
Evaluate SQL-Transact SQL (T-SQL) Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
SQL Server 2016 preview shows off new features, improvements
Experts discuss the public preview of SQL Server 2016 and the best new features as early adopters ready themselves to put SQL Server 2016 into production. Continue Reading
-
How to improve OLTP with SQL Server 2014 In-Memory
Basit Farooq explains how to improve the performance of OLTP applications using SQL Server 2014 In-Memory. He details what makes SQL Server 2014 In-Memory different from other in-memory database engines and how to use that to your advantage. Continue Reading
-
Digging deeper with T-SQL system functions and language tools
Learn how system functions can be used in T-SQL to view general session and system information along with other types of data in Microsoft SQL Server. Continue Reading
Manage SQL-Transact SQL (T-SQL)
Learn to apply best practices and optimize your operations.
-
Two ways to encrypt database backups with SQL Server
SQL Server 2014 provides two features that let database administrators easily encrypt database backups. An expert provides two demos that show you how. Continue Reading
-
Create a user-defined server role in SQL Server 2012 with T-SQL, SSMS
Ashish Mehta shows two ways – with T-SQL and with SSMS -- to make a user-defined server role in SQL Server 2012. Continue Reading
-
Nine T-SQL best practices
Choosing the right data type and avoiding dynamic SQL are two of the nine T-SQL best practices that author Basit Farooq explains here. 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.
-
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
-
Can SQL combine tables like these? Doubtful
Can SQL combine tables where the values don't relate to one another? One expert says it's difficult unless you redesign the tables. Continue Reading
-
SQL PIVOT helps merge results into a single row
SQL Server expert Denny Cherry shows how code can be used to the same effect as a SQL PIVOT statement. Continue Reading