SQL Triggers and Cursors - duck lips tucked in, we're using a cup today! All those learning to read SQL with Triggers and Cursors, what did you think about how you were going to explain these functions?
I look at this portion of SQL and consider never using it. However, the multiple que for every value within this itinerary is appeasing. I think of an actual programming skill, how to activate what you want and when it's going to happen in this fantastic attempt of learning how to put it so it works just as it is intended to be! There is no tone here, just factual delight that this has to come from another developer in the modularizing of SQL itself. Learning everything up to Views thus far and Stored Procedures into this section - I feel like the visualization and flow of what it is doing, is a borrowed system. It feels, temporary.
The Triggers are able to aim and pull an activation that sets off a series of events and possibly cursors (multi-dimensional arrays) of values to get the job done. The effect is simple. I understand it. However, the @@FETCH Status does not fit well with me, hence the name to retrieve as a unit together that arrives from something that should be separate one-at-a-time. It is hard to keep these functions separate, since they work together, but the connection that can be made using a regular JOIN statement should suffice this. Why use the @@FETCH command if it doesn't have its own story?
@@FETCH has a definition that sounded like a space tool that roves and collects like the trash collector repurposed essence in the form of a hired hand. This explained how it could loop throughout the code and bring forth its full bounty. The part that I want to know more about this is how does a @@FETCH Status resource the variable? Does that variable then become empty? Does it change? Is it labeled differently after, in programming? Using this style of looping in SQL does set it apart from other programming languages but I noticed the similarity between robotic programming as well. The SQL is interacting with binary commands that exchange a defined peice of space to explain how those variables were attained. This is attracting my vision of what SQL authors envisioned a database as and what they were doing to pick at specific components with a fine-tooth comb tool. It is simple and it creates the world of it as plausible as possible.
You know this can get more complex.
Using @@FETCH with Triggers and Cursors is more like the watering can than a gun. Perhaps, you aim for one target (one fieldName and dataType) while grouping the collected to be useful by value for whatever data needs to be collected. I think this can go further and explain how this role can be switched by nurturing the data sets by root or phase of its appearances. If programming buds bugs, because this is something that does happen on its own, then where do these root indicators appear if they transform out of reaction? The code that leaves its program succeptible can be prevented by use of a trigger to watch all variables in any process as a threat. As soon as it becomes a threat, the target assumes it wherever it is.
Easier said than done but out of purpose of database - it doesn't have a security wall that I want within how the code is structured (that I know of yet since I am still learning). One of the faults I learned with programmers when creating software designs is not having the plans for effective cyber security. It becomes a business and with that, more inputs and outputs to account and monitor which can also decrease runtime.
The only way it moves is because of the @@FETCH command?
The interaction after in any collected data set is isolated and the @@FETCH command breaks it apart and brings back to its roots instead of the polymorphism that has been accepted in OOP. Normalization is another process to consider in this that would have to be redefined. 0NF is ideal to contain all root values while 1NF would be processed during programming. These levels are attained with their own mapping that @@FETCH can be considered a spatial tool designed to break down and monitor any changes.
I may be out of context but it was something that bothered me as I learn this portion of SQL. Getting the syntax confused with other programming languages like robotics and visual basic prove that these develops laid down a framework to integrate other languages like C# (example) to be more poetic in grammatically challenging avenues that uphold its logic. The logic is such a hassle to deal with if you are not accustomed to think instructionally and ponder at the minor details of how things work.
My suggestion for any programmer learning to deal with getting stuck, read a book that lets you read it. Poetry I do not suggest. Read something that lets you complete the line, give it character where you can in your voice, and read like it is fun. This blockage is cleared, you feel like a success, and you assure yourself that you can read.
