| |
| |
|
|
T-SQL 2005 Articles and Tips
|
SQL Server Magazine - 11/2005
T-SQL 2005 -
Developers Win Big - Microsoft has made a number of
enhancements to T-SQL, including improvements to the TOP clause, support
for common table expressions (CTEs), new PIVOT and UNPIVOT operators,
the addition of Data Definition Language (DDL) triggers, and a new
TRY-CATCH error-handling structure.
XML, T-SQL, and the CLR Create a New World of Database Programming -
Transact-SQL now conforms more closely to the ANSI-99 SQL specification
and makes querying more flexible and expressive.
Choosing Between the CLR and T-SQL in SQL Server 2005 - The CLR integration
features in SQL Server 2005 enable managed code to run inside the database, but
developers now need to choose between CLR-based features and T-SQL when building
applications. Find out when each is appropriate.
Editing Transact-SQL Code in SQL Server 2005 Beta 2 - Get an overview of the
T-SQL development tools available in Microsoft SQL Server 2005 Management
Studio.
SQL Server 2005 Beta 2 Transact-SQL Enhancements - This white paper
introduces several of the new enhancements to Transact-SQL in Microsoft SQL
Server 2005 Beta 2.
T-SQL 2005 Article index - Several SQL Server magazine articles on T-SQL
2005
T-SQL in SQL Server 2005
- Changes and improvements to SQL Server 2005, focusing on what drives SQL
Server and T-SQL.
T-SQL
Enhancements in SQL Server 2005 - Sql server 2005 includes new Transact-SQL
(T-SQL) functionality. The enhancements span the range from an alternative
mechanism for transaction isolation to declarative support for hierarchical
queries. Sample book chapter is provided courtesy of Addison Wesley
Professional.
T-SQL Q
and A - MSDN Developer Center questions and answers on SQL 2005 webcasts.
T-SQL vs. the CLR in SQL Server 2005- How Should You Choose? - In this
webcast, we'll discuss how CLR-based code might be a better choice over T-SQL
for computation and logic-intensive operations. In addition, .NET
languages such as Microsoft Visual C# and Microsoft Visual Basic .NET provide
better looping and branching constructs than T-SQL does.
T-SQL Enhancements in SQL Server 2005 - By now you have heard that you
can write stored procedures in C# and VB .NET for SQL Server 2005. Does that
mean TSQL is dead? NO! A lot has changed in the world of TSQL for SQL Server
2005. Come see the new features of T-SQL for SQL Server 2005, including features
such as error handling and XML manipulation, that have been added to make
developing with SQL Server easier and more productive.
XML,
T-SQL, and the CLR Create a New World of Database Programming - Transact-SQL
now conforms more closely to the ANSI-99 SQL specification and makes querying
more flexible and expressive.
|
|
|
|
|
