创建存储过程的基本格式：
Create procedure update_createtime
@tbID int
as
update t_member set createTime = GetDate() where tbID = @tbID
go
添加返回值时就可以这样做
--Developer:zhihui Zhou
--Date：New（）as 2008-10-18
--Email：zhou5791759@163.com
--QQ:297510342
Create procedure update_createtime
@tbID int,
@createTime nvarchar(50) output
as
update t_member set createTime = GetDate() where tbID = @tbID
set @createTime = (select createTime from t_member where tbID = @tbID)
go
执行这个存储过程：
--Call SQL in the method for
--start
declare @createTime nvarchar(50)
exec update_createTime 1,@createTime output
--end
来源：http://www.cnblogs.com/zhou5791759/archive/2008/10/19/1314292.html