SQL/Transact SQL (T-SQL)

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#