CODEWITHSUNDEEP
phpsql-serverpdo
ashish bhatt
ashish bhatt

Reputation: 3151

How to get last inserted record from sql server using PHP PDO

I am trying to insert data in sql server 2005 using PDO object in PHP.

Also I want to retrieve last inserted id which is auto generated.

any one help me.

Upvotes: 0

Views: 520

Answers (1)

benjamin moskovits
benjamin moskovits

Reputation: 5458

In the session that the insert occured issue a 

select scope_identity()

will return the last generated identity column inserted.

Upvotes: 1

Related Questions