sql interview questions shared by candidates
SQL - Trigger, Stored Procedure, SQL Basics, truncate & delete HR - Joins, Multirow functions
Trigger is a kind of special stored procedure which will execute automatically when a when an event occures in database server.
Stored procedure is a prepared SQL code which is saved for reusing.
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.