xs_update2.sql

有读者和图书信息的添加查询,借还书等,先建立数据库和ODBC数据源

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