CREATE PROCEDURE AddBook
@name varchar(100),
@type   smallint,
@author   varchar(30),
@translator  varchar(30),
@publisher  varchar(100),
@price  decimal,
@discount  decimal,
@cover  image,
@description  text,
@hits  smallint,
@sales  smallint,
@status   bit
as
          insert book(type,name,author,translator,publisher,price,disount,cover,
description,hits,sales,status)values(@type,@name,@author,@translator,@
publisher,@price,@discount,@cover,@description,@hits,@sales,@status)
   GO
提示要声明变量@ 请求大家帮助