急求存储过程的修改，在线等！！

Question

try:
Create proc jiaohuan
as
declare @aa int
select @aa=count(*)  from enterprise_basicinfo_request where REQUEST_DEPT= '0000' 
insert into jiaohuanrizhi(rizhiriqi,bumenbianhao,xukebianhao,xukedaorushumu,jianguandaorushumu,jichudaorushumu)  Values(getdate(),'0000','','','',@aa)

Answer 1

把declare @aa int, 后面的','去掉

Answer 2

执行语句后是
服务器: 消息 156，级别 15，状态 1，过程 jiaohuan12，行 4
在关键字 'select' 附近有语法错误。去掉','就成功

Answer 3

Create proc jiaohuan
   as
  declare @aa int
  select @aa=count(*)  from enterprise_basicinfo_request where REQUEST_DEPT= '0000'
  insert into jiaohuanrizhi(rizhiriqi,bumenbianhao,xukebianhao,xukedaorushumu,jianguandaorushumu,jichudaorushumu)  Values(getdate(),'0000','','','',@aa)
  
  go