We got tremendous response to our very first video of SQL in Sixty Seconds #001 and SQL in Sixty Seconds #002. We talked about how to convert Subquery to CTE and Error and Reaction. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we believe would be helpful to readers.
In today’s SQL in Sixty Seconds Vinod Kumar has presented very visual reach concept of SQL Server. 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.
I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can. Do you know any such tricks
Reference: Pinal Dave (http://blog.sqlauthority.com)