How to retrieve the Id session number of the executed query ?

Question

Hello,

in PDO_SQLDRV i'd like to retrieve the Id session number of a query when I use $pdo->query($StringQuery)

Thanks for your help.

Answer 1

Bruno-

I'm not sure I understand your question. Are you looking for the PDO::lastInsertId method? If not, can you elaborate on what you are trying to do?

Thanks.

-Brian

---

This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/brian_swan

Answer 2

If you want your SQL Server session ID (from your connection) you can run this query from your PDO connection:

SELECT @@SPID

---

Rob