About this document
SQL Stored Procedures and Transactions Guide by abdi is a document available to read on EtoBox.
The document discusses creating stored procedures in SQL. It provides examples of creating procedures to return lists of titles or employees for a particular type or project. It also discusses creating a procedure to delete a department and reassign its employees. The document demonstrates transactions by updating a title name in an implicit transaction, which locks the table for other clients until the transaction is committed.
- Author
- abdi
- Language
- EN