In this lesson we will learn how to use a CURSOR for cyclic processing of a selection from tables. That is, a cursor is needed to process, for example, each row of a selection, table or view.
We write the code in T-SQL.
You will find materials for the lesson at the link: https://yadi.sk/d/5v__jyBRM9ZszA
After completing the entire course (lessons), you will have a small system for accounting of goods in a warehouse in Excel, working with a Database. You will be able to write it yourself, and also expand it at your own discretion.
Some excerpts from this video course: • Вышел Видеокурс Погружение в SQL + vba
If you feel that you lack knowledge of SQL, then take my other course for beginners in SQL: • SQL Для Начинающих - I explain it simply and accessibly.
And also if you feel that you lack knowledge of VBA, then take my course for beginners on VBA • Программирование для всех начинающих. Изуч... - I explain simply and accessibly "to the point of nausea" :)
My video courses:
Programming for Beginners - http://robotobor.pro/programming-for-...
SQL for Beginners - http://robotobor.pro/sql-for-beginners
Video course "Dipping into the VBA language" - http://course.robotobor.pro/dipping-t... - Professional programming in VBA
Video course "Dipping into SQL+vba" - http://course.robotobor.pro/dipping-t... - Professional programming in SQL+ADO+VBA
Our official website: http://robotobor.pro
Our VKontakte Group: https://vk.com/robotobor_pro
Our Instagram: / robotobor_pro
My C#.NET Instagram: / csharp_dotnet
#robotobor #programming #ityoutubersru #code #sql #output #vba #ado #recordset #activexdataobjects #immersion #storedprocedure #sqlserver #cursor #cycle
On this page of the site you can watch the video online Dive into SQL+vba - Course | Lesson 20 | Cursor - CURSOR. Processing a Table with a Cycle | SQL+E... with a duration of hours minute second in good quality, which was uploaded by the user ROBOTOBOR.PRO ✌ Доступное Программирование 14 April 2020, share the link with friends and acquaintances, this video has already been watched 6,238 times on youtube and it was liked by 135 viewers. Enjoy your viewing!