Question

SQL存储过程 ')' 附近有语法错误。

use mastergo
alter proc InsertData(@NAME nvarchar(200),@TITLE nvarchar(50),@CONTENT nvarchar(50),@FORMATCONTENT nvarchar(50),@INPUTDATE Datetime,@INPUTSOURCE nvarchar(50),@CATECODE nvarchar(50),@success int output)asbegin begin tran --开始执行事务 declare @errorNum int set @errorNum=0 declare @KEYID bigint declare @KNOWID bigint declare @WORDID bigint declare @KNOWCATE bigint insert into KEYWORDSDATA([NAME]) values (@NAME) set @KEYID=@@IDENTITY set @errorNum =@errorNum+ @@error insert into KNOWLEDGE(TITLE,[CONTENT],FORMATCONTENT,INPUTDATE,INPUTSOURCE) values(@TITLE,@CONTENT,@FORMATCONTENT,@INPUTDATE,@INPUTSOURCE) set @KNOWID=@@identity set @errorNum =@errorNum+@@error
insert into KEYWORDS(KNOELEDGEID ,KEYWORDSCODE) values(@KNOWID,@KEYID) set @WORDID=@@identity set @errorNum =@errorNum+@@error insert into KNOWLEDGECATE(KNOWLEDGEID,CATECODE) values(@KNOWID,@CATECODE) set @KNOWCATE=@@identity set @errorNum =@errorNum +@@error if @@error<>0 --判断如果两条语句有任何一条出现错误begin set @success=0 rollback tran endelse --如何两条都执行成功begin set @success=1 commit tran endendgo
exec InsertData 'sdf','sefe' ,'frv' ,'adfe' ,getdate(),'saefa' ,'aea' ,'1';select * from KEYWORDSDATAselect * from KNOWLEDGEselect * from KEYWORDS
exec InsertData 'sdf','sefe' ,'frv' ,'adfe' ,getdate(),'saefa' ,'aea' ,'1';
报错显示在这一行！！！





Answer 1

执行存储过程的时候，参数不能是GETDATE()这样的函数，需要定义一个变量，把函数的值放到变量中才可以。
exec InsertData 'sdf','sefe' ,'frv' ,'adfe' ,getdate(),'saefa' ,'aea' ,'1';
你可以试试，把getdate()换了，就不是报这个错误了，你要用getdate()，就在过程里面定义变量，赋值为getdate()

Answer 2

alter proc InsertData

@NAME nvarchar(200),@TITLE nvarchar(50),@CONTENT nvarchar(50),@FORMATCONTENT nvarchar(50),
@INPUTDATE Datetime,@INPUTSOURCE nvarchar(50),@CATECODE nvarchar(50),@success int output

不需要括号