SQL/Transact SQL (T-SQL)
Home > SQL Server Topics > Microsoft SQL Server Database Development > SQL/Transact SQL (T-SQL)
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS     RSS FEEDS 

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. They do so by sending T-SQL statements to the server. Improve your T-SQL skills with these T-SQL examples, best practices and stored procedures.
IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (156) , REFERENCE & LEARNING (59) , NEWS (1) , WHITE PAPERS , DOWNLOADS (1) , DEFINITIONS (10)

MUST READ
Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
TIP - Learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it's often confused with these two primary date/time data types.
SQL Server data conversions from date/time values to character types
TIP - Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.
How to use rank function in SQL Server 2005
TIP - With ranking functions in SQL Server 2005, you can rank rows in result sets. This tip defines rank functions and gives examples of how to use the four available functions.
Exception handling best practices in SQL Server 2005
TIP - SQL Server 2005 brings you TRY/CATCH, a new T-SQL feature that helps find and address errors before they reach application code. Get best practices for working with it.
Create DDL table in SQL Server 2005 to audit DDL trigger activity
TIP - Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.

  EXPERT TECHNICAL ADVICE: 1 - 3 of 156
Working with sparse columns in SQL Server 2008
Submitted By: SearchSQLServer.com | 02 Jun 2009
TIP - Sparse columns can provide significant storage benefits to those working with SQL Server 2008. Learn the proper way to implement sparse columns, column sets and filtered indexes.
Determining the source of full transaction logs in SQL Server
Submitted By: SearchSQLServer.com | 27 May 2009
TIP - Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
New GROUP BY option provides better data control in SQL Server 2008
Submitted By: SearchSQLServer.com | 05 May 2009
TIP - GROUPING SETS in the GROUP BY clause trumps the ROLLUP and CUBE options by providing a more efficient and specific data aggregator, as well as more control over data.
VIEW ALL EXPERT TECHNICAL ADVICE ON SQL/TRANSACT SQL (T-SQL)

  REFERENCE & LEARNING: 1 - 3 of 59
Top 10 SQL Server development tips of 2008
Steve Cimino, Assistant Editor | 07 Jan 2009
THE YEAR IN REVIEW - From converting date/time values into character types to retrieving XML data values with XQuery, these were the top 10 SQL Server development topics of 2008.
Additional T-SQL operations in SQL Server 2008
SearchSQLServer.com | 15 Oct 2008
BOOK EXCERPT - Learn how scalar operators, global variables and NULL values can be utilized in Transact-SQL in SQL Server 2008 in this book excerpt.
SQL Server 2008 function types in T-SQL
SearchSQLServer.com | 15 Oct 2008
BOOK EXCERPT - Functions in Transact-SQL can be either aggregate functions or scalar functions. This excerpt from "Microsoft SQL Server 2008: A Beginner's Guide" describes both.
VIEW ALL REFERENCE & LEARNING ON SQL/TRANSACT SQL (T-SQL)

  NEWS: 1 - 1 of 1
SQL Server permissions and new objects
Addison-Wesley | 28 Feb 2005
ARTICLE - Learn about SQL Server permissions and new objects in this excerpt from "A First Look at SQL Server 2005 for Developers."
VIEW ALL NEWS ON SQL/TRANSACT SQL (T-SQL)

  WHITE PAPERS
Effects of Solid State on Microsoft SQL Server 2008
Published by: Kingston Technology Company, Inc. | 08 Jul 2009
WHITE PAPER - This whitepaper contains the results of testing conducted to better understand how Kingston solid-state disk positively affects the scalability of Microsoft® SQL Server® 2008 databases. The findings shown here are from the end user's perspective, using TPC-C-like benchmarking of a large OLTP database.
Real Time Data Integration: Using Change Data Capture Technology with Microsoft SSIS
Published by: Attunity Ltd. | 08 Jul 2009
WHITE PAPER - Change data capture (CDC) technology has become a strategic component of many data warehouse and business intelligence (BI) architectures. Read this paper and learn how to use change date capture technology with Microsoft SQL server intergration services in real time.
Databases and ERP Selection: Oracle vs SQL Server
Published by: IFS | 19 Jun 2009
WHITE PAPER - How do Oracle and Microsoft SQL Server database platforms compare on reliability, scalability and cost when run under enterprise software? Download this white paper for details.
VIEW ALL WHITE PAPERS IN THIS TOPIC
  DOWNLOADS: 1 - 1 of 1
PromptSQL
Published by: PromptSQL | 23 Nov 2005
DOWNLOAD - PromptSQL is an add-on application that provides auto-complete functionality as you type for programs used to create SQL statements. It works with QA, UltraEdit32, Visual Studio.NET 2003, Visual Studio 2005 and SQL Server ...
VIEW ALL DOWNLOADS ON SQL/TRANSACT SQL (T-SQL)

  DEFINITIONS: 1 - 3 of 10
T-SQL
25 Apr 2002
WORD - 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, ...
OLE DB
30 Jul 2001
WORD - OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources. OLE DB includes not only the Structured Query Language (SQL) capabilities of the Microsoft-sponsored ...
query
27 Jul 2001
WORD - In general, a query (noun) is a question, often required to be expressed in a formal way. The word derives from the Latin quaere (the imperative form of quaerere, meaning to ask or seek). In computers, what a user of a ...
VIEW ALL DEFINITIONS ON SQL/TRANSACT SQL (T-SQL)

SEE ALSO - Topics Related to SQL/Transact SQL (T-SQL): 
SQL Server Database Modeling and Design, SQL Server Stored Procedures, XML in SQL Server, SQL Server Business Intelligence (BI) and Data Warehousing, .NET Development for SQL Server



SQL/Transact SQL (T-SQL) Solutions - SQL Server Topics

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts