我对这个问题有点困难,因为我不确定如何在sql Server中执行此操作.
@H_403_2@基本上,我想在数据库中插入一个新行,获取刚刚插入的PK值(相同的查询)并将其输出回任何称为存储过程的行:
CREATE PROCEDURE Users_Insert -- Add the parameters for the stored procedure here @userid int output,@name varchar(50),@surname varchar(50),@email varchar(200),@password varchar(50),@location varchar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here insert into Users(FirstName,LastName,Email,Password,Location) values(@name,@surname,@email,@password,@location); GO @userid = @@IDENTITY; END@H_403_2@我在MysqL中完成了以下操作:
CREATE PROCEDURE Users_Insert(@userid int output,@location varchar(50) BEGIN insert into Users(FirstName,@location); set @userid = last_insert_id(); END@H_403_2@sql Server给我一个错误:
@H_403_2@Msg 102,Level 15,State 1,Procedure Users_Insert,Line 18@H_403_2@坦率地说,我不确定我是否正确地声明了输出参数,有人能提出建议吗? @H_403_19@
Incorrect Syntax near ‘@userid’.
解决方法
您需要将值分配给@userid!另外,我建议使用SCOPE_IDENTITY()而不是@@ IDENTITY:
CREATE PROCEDURE Users_Insert -- Add the parameters for the stored procedure here @userid int output,@location); -- make an actual **assignment** here... SELECT @userid = SCOPE_IDENTITY(); END@H_403_2@See this blog post for an explanation as to WHY you should use
SCOPE_IDENTITY
over @@IDENTITY
@H_403_19@
@H_403_19@ 原文链接:https://www.f2er.com/mssql/76330.html