SQL/Transact SQL (T-SQL)

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 157

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

	The sqlcmd utility in SQL Server 17 Dec 2008 TIP - The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures.

	How to create a SQL inner join and outer join: Basics to get started Submitted By: SearchSQLServer.com | 03 Dec 2008 TIP - Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.

	Avoid cursors in SQL Server with these methods to loop over records Submitted By: SearchSQLServer.com | 17 Nov 2008 TIP - Avoid using a SQL Server cursor for looping over records row by row. Alternate methods use temp tables instead of SQL cursors that slow down performance.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL/TRANSACT SQL (T-SQL)

REFERENCE & LEARNING: 1 - 3 of 81

	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 - 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

	E-Guide - Best Practices for Sharepoint Server 2007 Backup and Disaster Recovery Published by: AvePoint, Inc. | 07 Jan 2009 EDITORIAL RESOURCE GUIDE - This informative E-Guide, brought to you by SearchWinIT.com and AvePoint, highlights best practices for SharePoint Server 2007 backup and disaster recovery.

	Is JD Edwards EnterpriseOne Right for Your Business? Published by: Oracle Corporation | 07 Jan 2009 IT BRIEFING - JD Edwards EnterpriseOne is a comprehensive and highly integrated suite of core business applications including things like financials, manufacturing, distribution, supply chain management, human capital management and so forth.

	E-Guide - How to Backup Sharepoint Server 2007 Published by: AvePoint, Inc. | 19 Dec 2008 EDITORIAL RESOURCE GUIDE - In this E-Guide, brought to you by SearchWinIT.com and AvePoint, explore an overview of the SharePoint backup and restore utility.

	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#