Click here to Skip to main content
15,888,802 members
Search within:


inserted row Primary Key
Please Sign up or sign in to vote.
0.00/5 (No votes)
How will you get the just inserted row Primary Key.?
Posted
Add a Solution

2 solutions

Have a look at SCOPE_IDENTITY()[^]

Read to the bottom how SCOPE_IDENTITY and @@IDENTITY differ
 
Share this answer
 
Posted
Comments
Timberbird 8-Nov-11 8:23am    
My mistake, SCOPE_IDENTITY() does suit OP purpose better
Try selecting @@IDENTITY[^]
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How do I insert a row of values to a table with a composite foreign key that includes the primary key?
Violation of PRIMARY KEY constraint 'PK__student__3213E83FBB0F63EB'. Cannot insert duplicate key in object 'dbo.student'. The duplicate key value is (1).
How to solve violation of PRIMARY KEY constraint 'PK_teacher'. Cannot insert duplicate key in object 'dbo.teacher' on NIOS registration site?
Python MYSQL primary key insert as foreign key in table
Django.db.utils.integrityerror: the row in table 'jobs_jobs' with primary key '1' has an invalid foreign key:
Insert a new row into a table ith nhibernate when the primary key is an identity column
Cannot insert duplicate key row in object 'dbo.test' with unique index
insert into table with primary key
inserting values into foreign key table and primary key table
Master Detail Datasets - Getting Primary Key value after insert

Advertise
Privacy
Cookies
Terms of Use
Last Updated 8 Nov 2011
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900