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)
3 Comments. Leave new
Can you give me other article site to refer more about T-SQL constructs?
this is nice one
I really like your SQL in 60 Seconds idea, very cool and to the point. Cudos to you and your team!
CASE WHEN a IN (1,2,3,4,5) THEN ‘ok’ ELSE ‘Not-OK’ END