database - SQL Stored Procedures for data access -

i have been asked make simple sql person table , ensure data access sql table via stored procedures.

can please have quick explanation of statement? instead of using insert statement table, call function instead?

if possible, can have quick example of using stored procedure insert standard information database has following fields:

• first name
• last name
• three address lines
• mobile phone
• home phone
• date modified
• person category

comment

if using ms sql server. like:

create table person (     firstname varchar(25),     surname   varchar(25) ) 

then stored procedure (this improved using transaction, if multiple tables needed added etc):

create procedure usp_insertnewperson (     @firstname varchar(25),     @surname varchar(25) )   begin     insert person(firstname, surname)     values (@firstname, @surname) end 

to call stored procedure:

exec usp_insertnewperson 'darren', 'davies'