xs_update0.sql

本人自己编写的!!!!!看看这样做的怎么样

create procedure xs_update0
  @jszh char(8),@xm char(8),@zym char(12),@xb bit,@cssj datetime,@jss int
as 
  delete xs
        where 借书证号=@jszh
  insert xs(借书证号,姓名,专业名,性别,出生时间,借书数)
        values(@jszh,@xm,@zym,@xb,@cssj,@jss)