Hey there, i feel blessed to keep in touch with you, through asking questions. As a newbie sql learner i have a general enquiry. I learned that a module can contain routines, procedures, or SQL commands. What is the distinct difference between those three components. Thanks for taking care of this.
Hi Hasan, A stored routine is nothing but either a procedure or a function. A procedure is invoked using a CALL statement and can only pass back values using output variables. SQL Command is just a logical statements which performs Create, Read, Update and Delete. Hope this helps :)
Thanks for the simple solution I was searching online finally found the solution ☺️
Great video for stored procedure tutorial. Many Thanks !!
Thank You MS
Hey there, i feel blessed to keep in touch with you, through asking questions.
As a newbie sql learner i have a general enquiry.
I learned that a module can contain routines, procedures, or SQL commands.
What is the distinct difference between those three components.
Thanks for taking care of this.
Hi Hasan,
A stored routine is nothing but either a procedure or a function.
A procedure is invoked using a CALL statement and can only pass back values using output variables.
SQL Command is just a logical statements which performs Create, Read, Update and Delete.
Hope this helps :)