SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite 8

Compound Assignments in SQL Server 2008

Two of the new T-SQL enhancements in SQL Server 2008 are the inline variable initialization and compound assignments (also called delighters). We had those for a long time in languages like C, C++, C#, VB, and they are just coming to T-SQL.

Duration:
2 mins 10 secs
Skill Level:
100
Rating:
4.16 out of 5
Publish Date:
November 03, 2008
Compound Assignments in SQL Server 2008 You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Plamen Ratchev
Plamen Ratchev has over two decades experience in the software architecture and development field. He has enjoyed building solutions for UNIX, DOS and Windows platforms, with main focus on SQL Server since version 4.21. Plamen is founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance a...

References

There are no downloads or recommended reading links for this video

Comments
Tahir A. Syed on 3/4/2009
Interesting & increase my knowledge. Thanks, Tahir

JAJATI BADU on 3/4/2009
Best

Steve Allen on 3/4/2009
nice, succinct.

Jay Trombly on 3/4/2009
Accent made it a bit difficult to understand at first, but presentation was clear overall.

Mohit on 3/5/2009
Very Good Videos for Beginners

Kris Robinett on 3/6/2009
a little difficult to understand the presenter. He sounds like he is in a room where someone is sleeping and he wants to be quiet.

Mike Mastro on 4/30/2009
should of done a select on the second example to show the before and after of the data... kind of hard to follow in that sense...

Susan McLoughlin on 7/29/2011
It would have been better if he actually explained what a compound assignment actually is rather than saying it's the same thing used in other languages.

Dick Rosenberg on 7/29/2011
Didn't understanmd what was new about the seciond opart

John O'Sullivan on 7/29/2011
useful tip

Mark Horninger on 7/29/2011
Very hard to follow - author has a heavy accent. but good information!!!!

Joe on 7/29/2011
Nice!

Joe Celko on 7/29/2011
This does not port to any other SQL or to Stanadard SQL. We will need a macro in the text edit to work with it.

Vua on 7/29/2011
I know about this but thanks for remind.

erick on 7/29/2011
REALLY NICE

Paul E Richmond on 7/29/2011
Clear and concise! Great presentation.

Ron on 7/29/2011
Nice. Now, if we would only upgrade our data store to '08...

Joe DeMarco on 7/29/2011
Pretty basic

B on 7/29/2011
he is very hard to understand due to his accent

li lin on 7/31/2011
this is great, I didn't know tsql can do this before

Mat on 7/31/2011
simple

Vamsi on 8/1/2011
good

Chandru on 8/4/2011
I didnt know this is compound assignment, but I have been using it ..... :)

Art Scafide on 8/24/2011
The video does not show how this saves time...?

Plamen Ratchev on 8/25/2011
Art, this saves time by allowing to perform data modification statements to two tables using a single query.

Laszlo Acs on 11/16/2011
Too elementary and not enough substance. More complexity and usage would be nicer

Maurice Ivory on 12/29/2011
Good information

Richard Scott on 3/5/2012
Good stuff.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions