Inline Variable Initialization in SQL Server 2008

Variable initialization in previous versions of SQL Server was always at least two lines of code. With inline variable initialization in SQL Server 2008 you can now initialize a variables value on the same line in which you declare the variable. This video shows you how this new feature works.

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...

Philip Hickey on 5/29/2009

This topic didn't deserve it's own video clip.

Terrance on 5/29/2009

Very good video on inline variable initialization.

Ed Svastits on 6/4/2009

good examples

Steve Harris on 6/9/2009

clear and concise

Eric on 7/30/2010

Great video, thank you. I am benefitting greatly from these SQL 2008 new features videos. However, this video could have been much shorter if the author had the SQL statements typed out already. In this video, the viewer spends a long time watching the author type out T-SQL statements.

Jeremiah on 10/18/2011

Awesome tip!!! This is a very useful tutorial today!!

Thirunavukkarasu on 10/18/2011

nice

Kasey Wheeler on 10/18/2011

Nice tip!

0F7D2DA586 on 10/18/2011

Overall the video was good and illustrated the use of in-line variable initialization in T-SQL. I think the video would have been more complete by illustrating multiple variables being initialized in one statement separated by commas. Not that someone couldn't figure that out on their own but if this was their first exposure the viewer might not realize it is an option.

Kevin Conan on 10/18/2011

The content is good, the video picture quality is too poor, it is very hard to read what he is typing

Thomas Kaiser on 10/18/2011

Excellent. Thanks for this informative example.

Craig Matthews on 10/19/2011

Please speak a little loader. Thanks

Kat on 10/21/2011

Nice example for eliminating steps and writing cleaner code. Thanks...this will be of great help.

michael murphy on 11/7/2011

thanks

John O'Sullivan on 11/7/2011

a useful tip

Shashank Banerjea on 11/7/2011

Simple topic to pick up but provide great examples.

Alexander on 11/8/2011

very nice and useful

heml on 11/8/2011

Verry Nice..!!!

Laszlo Acs on 11/16/2011

very interesting. I think a bit more usage and complexity could be demonstrated, including some practical uses