Summary
What you have learned in today's lesson is how cursors make your job as a SQL programmer easier. You have also gotten an understanding that using cursors requires you to do a bit more design and analysis of what actions you want to perform on the data before creating the SQL code. Remember that, although you might think that cursors are the best way of doing things, they require a great deal more effort, and, more importantly, they often provide you with poorer performance when executing the SQL scripts.
At this point, you have probably figured out that cursors allow you to use SQL statements just like a regular programming language. In addition, you saw that there are several things to watch out for when using cursors. Cursors can be ...
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.
