Link to home
Start Free TrialLog in
Avatar of cossy74
cossy74

asked on

GUID and last inserted row.

Hi,

i have a table with a uniqueidentifier(GUID) set to auto assign as it's primary key.
I would like to know the sql query that i can run after an insert statment to get the last row i just inserted?
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cossy74
cossy74

ASKER

aneeshattingal: I dynamically create a SqlCommand and execute it. I therefore do not think i can use your solution as i am not  using a stored procedure.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial