SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video

SQL SERVER - T-SQL Constructs - *= and += - SQL in Sixty Seconds #009 - Video 60

There were plenty of request for Vinod Kumar to come back with SQL in Sixty Seconds with T-SQL constructs after his very first well received construct video T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video. Vinod finally comes up with this new episode where he demonstrates how dot net developer can write familiar syntax using T-SQL constructs. T-SQL has many enhancements which are less explored. In this quick video we learn how T-SQL Constructions works. We will explore Declaration and Initialization of T-SQL Constructions. We can indeed improve our efficiency using this kind of simple tricks. I strongly suggest that all of us should keep this kind of tricks in our toolbox.

[youtube=http://www.youtube.com/watch?v=tla5Sv56MhM]

More on Errors:
Declare and Assign Variable in Single Statement
Declare Multiple Variables in One Statement

I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.

If we like your idea we promise to share with you educational material.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Database, SQL in Sixty Seconds, SQL Scripts
Previous Post
SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS)
Next Post
SQL SERVER – Difference between DATABASEPROPERTY and DATABASEPROPERTYEX

Related Posts

3 Comments. Leave new

  • Saurabh Savaliya
    March 28, 2012 5:02 pm

    Can you give me other article site to refer more about T-SQL constructs?

    this is nice one

    Reply
  • Mike Michalicek
    March 28, 2012 8:04 pm

    I really like your SQL in 60 Seconds idea, very cool and to the point. Cudos to you and your team!

    Reply
  • CASE WHEN a IN (1,2,3,4,5) THEN ‘ok’ ELSE ‘Not-OK’ END

    Reply

Leave a Reply