SQL Server 2000 has three similar functions: scope_identity, ident_current, and @ identity. Both return values inserted into the identity column.Nbsp; ident_current returns the final id value generated for any session and a specific table in any
@ @IDENTITY (Transact-SQL) returns the last inserted identity value of the system function.Note After an INSERT, SELECT into, or bulk copy statement is complete, the @ @IDENTITY contains the last identity value generated by the statement. If the
@ Identity (TRANSACT-SQL) returns the system function of the last inserted Identifier value.
Note: After an insert, select into, or large-capacity copy statement is completed, @ identity contains the last Identifier value generated by the statement.
Use SELECT @ @identity to get the ID that was automatically generated when the record was last insertedIf you use a stored procedure, it will be very simple, the code is as follows: SET @[email protected] @IDENTITYDescriptionAfter an INSERT, SELECT
[Original address:] The differences between scope_identity, ident_current, and @ identity (comparison)
@ Identity (TRANSACT-SQL) returns the system function of the last inserted Identifier value.
Note: After an insert, select into, or large-capacity
Source: The difference between @ @IDENTITY and @ @ROWCOUNT in SQL Drip 31-sql statementdifference between @ @IDENTITY and @ @ROWCOUNT in SQL statementsAfter an INSERT, SELECT into, or bulk copy statement is complete, the @ @IDENTITY contains the
SQL application series in SQL Server 2008-Directory Index
Yesterday, someone discussed in the group three functions that SQL Server returned the last IDENTITY value: IDENT_CURRENT, @ IDENTITY, and SCOPE_IDENTITY, and made some markup and
Select @ identity usage 11:25:39| Category: JSP Dev|Report|Font SizeSubscription Use select @ identity to obtain the ID automatically generated when the last record is inserted. If you use a stored procedure, the Code is as follows: Set @ [email
Use select @ identity to obtain the ID automatically generated when the last record is inserted. If you use a stored procedure, the Code is as follows: Set @ [email protected] @ identity Note: After an insert, select into, or large-capacity copy
Yesterday, someone discussed in the group three functions that SQL server returned the last identity value: ident_current, @ identity, and scope_identity, and made some markup and summary.
In fact, msdn has an official explanation for this: all
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.