Database Fundamentals/Stored Procedures
This lesson introduces stored procedures.
Objectives and Skills
editObjectives and skills for the stored procedures portion of Microsoft Exam 98-364 Database Fundamentals include:[1]
- Create database objects
- Create stored procedures and functions
- Select, insert, update, or delete data
- Create stored procedures and functions
Readings
editMultimedia
editActivities
edit- Use SQL Server to create stored procedures to update record information in the Student table in your College database.
- Create the following stored procedures:
- Apply the INSERT statement in a stored procedure to insert a new record into the Student table.
- Apply the UPDATE statement in a stored procedure to update the first name field in the previous step in the Student table.
- Apply the DELETE statement in a stored procedure to remove the record that you just added in the Student table.
Lesson Summary
edit- A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDMS). [2]
- A SQL injection is a code injection technique, used to attack data-driven applications, in which malicious SQL statements are inserted into an entry field for execution (e.g. to dump the database contents to the attacker). [3]
Key Terms
edit- SQL injection
- stored procedure