Day 11. T-SQL Programming Fundamentals
In the previous 10 lessons, you have learned how the basics of T-SQL work when accessing and modifying data in a relational database. You have seen how to create the actual database and how to create and use views and temporary tables. With this knowledge and a tool such as the Query Analyzer, you can write simple, SQL queries. By simple, I mean with little or no logic built into them.
In today's discussion, you will learn about the different programming structures that T-SQL provides to handle the expected tasks of conditional execution and program looping. In addition, you will learn how to define and use variables. If you are familiar with any of the object-oriented programming languages, such as Visual ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
