存储过程1 Create procedure spRetrieveAuthor @au_id varchar As select * from author where au_id=@au_id其中@表示变量名。调用方法举例:spRetrieveAuthor '001'