SQL/Transact SQL (T-SQL)
Home > SQL Server Topics > SQL Server 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 (151) , REFERENCE & LEARNING (77) , NEWS (5) , WHITE PAPERS , DOWNLOADS (1) , BEST WEB LINKS (3) , DEFINITIONS (8)

MUST READ
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.
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.
Using the OUTPUT clause for practical SQL Server applications
TIP - Learn how using the OUTPUT clause in SQL Server 2005 queries simplifies T-SQL code and returns results of rows changed by an INSERT, UPDATE or DELETE SQL command.
Optimize T-SQL data types in SQL Server
TIP - To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.

  EXPERT TECHNICAL ADVICE: 1 - 3 of 151
SQL/TRANSACT SQL (T-SQL) EXPERTS
Joe Toscano
SQL Server Business Intelligence consultant/Instructor
ASK A QUESTION
Greg Low
Lead SQL Server Consultant
ASK A QUESTION
SQL Server trigger vs. stored procedure to receive data notification
02 Oct 2008
EXPERT ANSWER - Learn why using a SQL Server stored procedures vs. a trigger can be a preferred method to retrieve data notification from a database field.
Manipulate column names in a SQL Server table
02 Oct 2008
EXPERT ANSWER - Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns.
Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
Submitted By: SearchSQLServer.com | 11 Sep 2008
TIP - Use SQL Server T-SQL datetime functions to retrieve specific data. Learn how to use GETDATE, DATENAME and DATEPART in SQL SELECT to extract datetime values.
VIEW ALL EXPERT TECHNICAL ADVICE ON SQL/TRANSACT SQL (T-SQL)

  REFERENCE & LEARNING: 1 - 3 of 77
Supertype and subtype tables in SQL Server
SearchSQLServer.com | 16 Sep 2008
BOOK EXCERPT - Learn how to physically implement supertype and subtype tables on a SQL Server in this book excerpt.
SQL Server and data manipulation in T-SQL
SearchSQLServer.com | 16 Sep 2008
BOOK EXCERPT - Learn about stored procedures, parameters, triggers and other T-SQL code functions in this book excerpt.
Enforcing data integrity in a SQL Server database
SearchSQLServer.com | 16 Sep 2008
BOOK EXCERPT - Find out how primary keys, foreign keys and constraints can keep your SQL Server data consistent in this book excerpt.
VIEW ALL REFERENCE & LEARNING ON SQL/TRANSACT SQL (T-SQL)

  NEWS: 1 - 3 of 5
Microsoft kills standalone WinFS file system
SearchWinIT.com | 26 Jun 2006
ARTICLE - Microsoft has pulled the plug on one of Bill Gates' pet projects just over a week after he turned the technical mantle of his company over to Ray Ozzie.
SQL Server DBMS' growing popularity is no coincidence
SearchSQLServer.com | 05.26.2006
OPINION - SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of ...
Best SQL Server products of 2005
SearchSQLServer.com | 16 Jan 2006
SPECIAL REPORT - The editors of SearchSQLServer.com sat down this past fall to assess the 2005 crop of products. Here are the winners in the General Database Utilities category.
VIEW ALL NEWS ON SQL/TRANSACT SQL (T-SQL)

  WHITE PAPERS
Who Can You Trust to Protect Your SQL Server Data?
Published by: Microsoft | 17 Sep 2008
TRIAL SOFTWARE - Microsoft System Center Data Protection Manager (DPM) 2007 is designed for the Database Administrator or the IT generalist and uses wizards and workflows to help ensure that you can protect SQL data-without requiring an advanced training.
Security of Microsoft SQL Server 2008 Improves over Previous Versions
Published by: Information Security Magazine | 11 Sep 2008
JOURNAL ARTICLE - The security features in SQL Server 2008 are well thought out and properly implemented, by far the most significant change over its predecessors is its granular data security features: encryption, key management and meta data security enhancements.
Deploying Microsoft® SQL Server™ 2005 with Microsoft Windows Server® 2008 on Dell™ PowerEdge™ Servers and Dell Storage
Published by: Dell, Inc. | 27 Aug 2008
WHITE PAPER - This white paper provides an architectural overview and configuration guidelines for deploying Microsoft SQL Server 2005 x64 SP2 with Microsoft Windows Server® 2008 x64 Enterprise or Standard Edition on Dell PowerEdge servers with Dell PowerVault.
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)

  BEST WEB LINKS: 1 - 3 of 3
SQL Server 2000 Survival Guide
http://www.akadia.com/services/sqlsrv_programming.html | 22 Jul 2005
BEST WEB LINK - Here you find step-by-step resources for architecting, administering and managing SQL Server 2000.
Microsoft SQL Server: Programming Forum
http://www.tek-tips.com/ | 22 Jul 2005
BEST WEB LINK - This active forum dedicated to SQL Server will give answers to SQL Server's most difficult questions.
SQL exercises
SQL exercises | 03 May 2005
BEST WEB LINK - Use this site to improve your skill in building SQL Data Manipulation Language statements.
VIEW ALL BEST WEB LINKS ON SQL/TRANSACT SQL (T-SQL)

  DEFINITIONS: 1 - 3 of 8
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): 
.NET development for SQL Server, Web services/SOA, SQL Server stored procedures, Visual Basic in SQL Server, XML in SQL Server, C#


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

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




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