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
T-SQL
SQL-Transact SQL (T-SQL) News
-
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 problems with concurrency issues, transferring stored procedure results and writing T-SQL. Continue Reading
Evaluate SQL-Transact SQL (T-SQL) Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
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
-
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 retrieving XML data values with XQuery, these were the topics that made you click in 2008. Continue Reading
-
Five sqlcmd features to automate SQL Server database tasks
Make your life easier with the sqlcmd tool in SQL Server 2005 that automates administration and maintenance via scripting. In this tip, you'll get five useful features and examples to execute sqlcmd commands, such as for utilizing and populating variables, improved error handling and restoring a database. Continue Reading
Manage SQL-Transact SQL (T-SQL)
Learn to apply best practices and optimize your operations.
-
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
-
SQL Server views: Creating indexes and adding base data
SQL Server views allow you to give information to users without compromising security. Find out how to create indexes on them and add base data. 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.
-
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
-
SQL Server views: What they are and how to create them
SQL Server views can help DBAs provide information to users while still controlling data access. Find out how. Continue Reading