SQL Server 2008 T-SQL Enhancements
Description
Curious to see what kinds of benefits SQL Server 2008 provides for developers? Check out this video tutorial to learn about T-SQL enhancements in SQL Server 2008 including: Row Constructors, Inline Variable Assignment, Compound Assignment Operators, and DML enhancements for the OUTPUT Clause. Likewise, get a sneak peak at the new T-SQL DML MERGE statement and Table-Valued Parameters.
This Video Covers
T-SQL enhancements, variable assignment, parameters, aggregates and summaries, and coding improvements.
Details
Length: 09:09
Skill Level: 200 - Intermediate.
Series: What's New in SQL Server 2008
Author: Michael K. Campbell
Applies to SQL Server: 2008.
Tags: What's New, T-SQL, and Easy.
Code Download: 2 KB
Video Resources
Video References, Video Transcript, and Accompanying Source Code.
Related Videos
Introducing SQL Server 2008, SQL Server Management Studio 2008, and Date and Time Data Types in SQL Server 2008
Viewer Comments
SQL Server Videos are available free of charge.
But you must agree to the following terms before downloading:
Redistribution is prohibited.
Redistribution via any of the following means is prohibited.
• WebServer/HTTP, FTP,
• YouTube and similar sites,
• BitTorrent,
• CD/DVD, Portable Hard-drive, etc.
I already Agreed to these Terms
Non-registered users must agree to terms upon each new visit to the site.
Registration costs nothing, is painless, and is evil-free™. And SSV will never divulge your personal information to third parties. Ever.
Registered Users
Login Here.
Thankx
thanks a lot.. v.good one
Excellent. You have made it very neat .Appreciate your work. Thank you for sharing.
please zip all videos for low speed clients
thank you
nice videos i understand sql server topics
Nice videos, Thanks a lot
MzUev1 Hi! I'm just wondering if i can get in touch with you, since you have amazing content, and i'm thinking of running a couple co- projects! email me pls
very very very nice videos
thankx alot
Hi there,
I believe there is an error in the query displayed at 2:38.
DECLARE @value2 int
SELECT @value = -1
I think it should be:
DECLARE @value2 int
SELECT @value2 = -1
^
This explains why the second column of the SELECT statement is NULL. @value2 is never initialized while @value is given a value of -1.
Am I right?
Really very good.