SQL - Procedure and Trigger
Über den Vortrag
Der Vortrag „SQL - Procedure and Trigger“ von Martin Holzke ist Bestandteil des Kurses „SQL Database for Beginners“. Der Vortrag ist dabei in folgende Kapitel unterteilt:
- Introduction - About Procedure Basics
- the Stall Procedure
- About Triggers
- Trigger Creation
Dozent des Vortrages SQL - Procedure and Trigger
Martin Holzke
Martin Holzke’s programming career started while studying Physics in the late 1980’s when he took on an offer to learn to program at Philips instead of the more common student jobs. Once graduated, he started his own business developing applications and systems as a freelance IT Consultant which he does to this day. His 25+ years’ journey continues to take him through a vast array of technologies, methodologies and languages like OOP, UML, C++, .NET, ADF, PHP, Zend, Oracle and SQL to name just a few.Kundenrezensionen
5,0 von 5 Sternen
| 5 Sterne |
|
5 |
| 4 Sterne |
|
0 |
| 3 Sterne |
|
0 |
| 2 Sterne |
|
0 |
| 1 Stern |
|
0 |
Auszüge aus dem Begleitmaterial
... to the table comments and verify that the trigger is working correctly. Answer: Insert into comments(notes) values (‘inserting a new note’) Post-test with: Select * from comments This should show the new record including primary key and timestamp. 6) Write a query adding a trigger to the table comments ...
... end; @@ delimiter; Note: This is a very basic solution lacking any error handling, etc. 10) Write queries adding a new project “SEO” with a budget of 400 using the above stored procedure and verify that the stored procedure works correctly. Answer: Call addproject(‘SEO’, 400); Post-test with: select * from project ...
