问一下,存储过程中两个@@这个符号是什么意思?
puzih 2006-11-10 01:58:59 问一下,存储过程中两个@@这个符号是什么意思?如下中:
CREATE Procedure AddUser
(
@UserName nvarchar(50),
@Password nvarchar(50),
@Name nvarchar(50),
@Email nvarchar(50),
@IDCardNumber nvarchar(50),
@TelephoneNumber nvarchar(50),
@UserID int OUTPUT
)
AS
INSERT INTO Users
(
UserName,
Password,
Name,
Email,
IDCardNumber,
TelephoneNumber
)
VALUES
(
@UserName,
@Password,
@Name,
@Email,
@IDCardNumber,
@TelephoneNumber
)
SELECT
@UserID = @@Identity
GO
上面的@@Identity是什么意思啊?谢谢