关于SQL存储过程的小疑点

create proc GetBookStatisticInfoasselect BookName,ISBN,Publisher,    总数=count(1)from tbgroup by BookName,ISBN,Publishergo
------解决方案--------------------
探讨

创建存储过程GetBookStatisticInfo
输入参数：无
功能：按BookName,ISBN,Publisher分组统计图书总数，给出（BookName,ISBN,Publisher，总数）信息。

------解决方案--------------------
其实,你这个没必要用储存过程,直接SQL语句即可.
SQL code
select BookName,ISBN,Publisher,count(1) 总数 from tb group by BookName,ISBN,Publisher
------解决方案--------------------
SQL code
create procedure GetBookStatisticInfoasbegin  select BookName,ISBN,Publisher,count(1)as 总数 from tb group by BookName,ISBN,Publisherend