Trigger is a kind of special stored procedure which will execute automatically when a when an event occures in database server.
2
Anoniem
18 aug 2018
Stored procedure is a prepared SQL code which is saved for reusing.
1
Anoniem
18 aug 2018
Truncate is similar to the delete command but it removes entire table. Delete is the command Which is used to remove some data by using where clause.
1
Anoniem
18 aug 2018
Singlerow functions are the one who work on single row and return one output per row. Multirow functions are the one who work on multiple rows and return one output for multiple rows.