PASS Community Summit 2008 - Program Sessions
SQL Server Heroes


Click to preview our action-packed agenda

PASS Community Summit 2008: Program Sessions (Application Development)



Programming T-SQL in SQL Server 2008, and Beyond!

Presenter:
Jim Hogg (Microsoft Corp.)

Co-Presenter:
Leonard Lobel (twentysix New York)

Session Details

Join Lenni and Jim for a session that will get you up to speed on the most exciting new T-SQL programmability features and enhancements in SQL Server 2008. Lenni will start by guiding you through new SQL Server 2008 T-SQL features, with live demos that clarify what's going on. Learn how to use Table Valued Parameters (TVPs) to marshal entire sets of rows across from client to server, and pass them between stored procedures. Then dig into MERGE, a powerful new DML statement that combines the capabilities of four (or more) separate operations. Next find out about INSERT OVER DML, which enhances our ability to capture change data from the OUTPUT clause of any DML statement. Finish with new date and time features, time zone awareness, and improvements in date and time range, storage, and precision. Then Jim will look ahead and share early thoughts from the Product Team on how to bring even more power to T-SQL, and more productivity to developers.

Register Now for PASS Community Summit 2008!