Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.
Triggers can't be invoked on demand. They get...
triggers are fired automatically but we need to call functions. Triggers can b fired on update, insert command. For example if there is field of phoneNumber. We need to validate phoneNumber on insert...
STORED PROCEDURE :A stored procedure can be created with no parameters, IN parameters, OUT parameters, or IN/OUT parameters.There can be many parameters per stored procedure.It is also called as a...
Closed wrap means that the tubing has several bends in order to be more compact.With an open wrap instrument, the tubing is shaped like a large loop to minimize the number of bends and, thus,...