SQL Server 2008 T-SQL Enhancements

SQL Server 2008 T-SQL Enhancements
15

- Details

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

Video Length: 09:09
Skill Level: 200 - Intermediate
Series: What's New in SQL Server 2008
Author/Presenter: Michael K. Campbell
Applies to SQL Server: 2008

Tags: Easy, and T-SQL

    Applicability

Analyst 5
DBA 40
Developer 45
Manager 10

 

- Downloads

+ Related Videos

+ Transcript

- Comments

Thankx

Ramu - November 11, 2009.

thanks a lot.. v.good one

samy - November 20, 2009.

Excellent. You have made it very neat .Appreciate your work. Thank you for sharing.

- February 21, 2010.

please zip all videos for low speed clients
thank you

roodgar - July 24, 2010.

nice videos i understand sql server topics

shankar - November 02, 2010.

Nice videos, Thanks a lot

Jose Musse - January 04, 2011.

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

WillSmith - February 19, 2011.

very very very nice videos
thankx alot

aria - June 10, 2011.

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?

- December 14, 2011.

Really very good.

Sultan, India - December 29, 2011.

خیلی خوب بود
very very good

babak of "IRAN"

babak - February 10, 2012.

the work is you do is appreciated keep it up!!!

Nyiko (South Africa) - February 10, 2012.

It's great video, it really help guy like me for developer

- March 25, 2012.

Nice Article.....

Nagendra - July 16, 2012.

Good One.

Prasad A - March 14, 2013.

Add A Comment

 

NOTE: Comments are moderated.

The following pseudo-markup is permitted:
      bold : text inside *stars* will be bold
      italic : text inside _underscores_ will be emphasized
      hyperlinks : [linktext|http://link.url.here]