Conclusion
Transact-SQL is an extension of straight SQL that makes it a true programming language. In this chapter, you saw all the operators available to you when you create SQL scripts and stored procedures. Next, you learned how you can perform looping operations in Transact-SQL by using the WHILE loop and the GOTO statement. Last, you saw some of the more frequently used system-defined functions available to you. All these aspects combined make Transact-SQL a rather powerful programming language.
Get Writing Stored Procedures for Microsoft SQL Server 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.
