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
提示要声明变量@ 请求大家帮助
@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
提示要声明变量@ 请求大家帮助
处用了硬回车吧,和下面单词写到一起。
description,hits,sales,status)values(@type,@name,@author,@translator,@publisher