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
Nesta página do site você pode assistir ao vídeo on-line Dive into SQL+vba - Course | Lesson 20 | Cursor - CURSOR. Processing a Table with a Cycle | SQL+E... duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário ROBOTOBOR.PRO ✌ Доступное Программирование 14 Abril 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 6,238 vezes e gostou 135 espectadores. Boa visualização!