CREATE PROCEDURE Pr_AddKey
{/*声明存储过程的参数*/
@Keyword_name varchar(20)
}
AS
/*声明局部参数,即存储过程中的参数*/
DECLARE @Keyword_name_count as int
/*局部参数赋值*/
SET @Keyword_name_count=
{
SELECT Count(*)
FROM tb_Keyword
WHERE [email protected]_name
}
IF @Keyword_name_count <=0
BEGIN
INSERT INTO
tb_Keyword(Keyword_name)
VALUES
(@Keyword_name)
RETURN @@Identity
END
sql2000提示语法错误或违反访问规则
------解决方案--------------------
请把花括号{}换成圆括号().