Store procedure is the way to manipulate your DB record on the server
side.
It's just SQL with several extentions for each DB (PLSQL for Oracle,
TSQL for MSSQL)
Asking how to change smth by SP has no sence.
What's your data and where would u like to change it?