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 156

	SQL language crash course (just enough to be dangerous) Submitted By: SearchSQLServer.com | 16 Sep 2009 TIP - You can't get far in the SQL Server world if you don't speak the language. Check out the basics of SQL language with examples of common SQL Server queries.

	Working with IntelliSense in SQL Server 2008 Management Studio Submitted By: SearchSQLServer.com | 14 Sep 2009 TIP - IntelliSense in SQL Server 2008 Management Studio provides easy access to language elements when writing T-SQL queries. Knowing the basics can simplify coding in a big way.

	SQL Server Mailbag: Stored procedures, triggers and SSRS reports Submitted By: SearchSQLServer.com | 03 Sep 2009 SQL SERVER MAILBAG - In this edition of the SQL Server mailbag, expert Denny Cherry tackles reader questions on creating stored procedures, editing data in SQL Server Reporting Services and more.

	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

	The IT Manager’s Guide to SQL Server 2008 Migration Published by: SHI | 03 Nov 2009 EGUIDE - While SQL Server 2008 is now considered stable and beneficial, many businesses are still hesitant to migrate. In this expert E-Guide, brought to you by SearchSQLServer.com and SHI, you will discover the unique advantages offered by a SQL Server 2008 migration.

Dell and Microsoft solutions help ServiceU deliver reliable system performance and create a virtualized environment that reduces power consumption by 50 percent Published by: Dell and Microsoft | 28 Oct 2009 CASE STUDY - ServiceU Corporation was challenged to deploy reliable hardware to support its Microsoft® SQL Server® 2008 environment and virtualize other applications to enhance business flexibility. Read this case study to learn about the benefits that ServiceU achieved through by implementing Dell hardware and Microsoft Hyper-V technology.

Are You Ready for Economic Bounce Back? Published by: Micro Focus UK | 27 Oct 2009 WHITE PAPER - This paper examines the concept that preparing for economic recovery is not something that can wait; it is something that businesses should plan for now. It will introduce enterprise application migration strategies that can be considered within any organization and also emphasize the importance of forward thinking and planning in down economy.

	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