How to get Insert id in MSSQL in PHP?

by

@@IDENTITY returns the most recent identity generated in the current session. In most cases you’ll probably want to use SCOPE_IDENTITY instead, which returns the most recent identity generated in the current scope.

For example, if you insert a row into table1, but that insert fires a trigger which inserts a row into table2, then @@IDENTITY will return the identity from table2 whereas SCOPE_IDENTITY will return the identity from table1.

INSERT INTO my_table (my_column) VALUES ('test')

-- return the identity of the row you just inserted into my_table
-- regardless of any other inserts made by triggers etc
SELECT SCOPE_IDENTITY() AS ins_id

More Related Contents:

  1. How to escape strings in SQL Server using PHP?
  2. PHP Fatal error: Call to undefined function mssql_connect()
  3. Connect PHP to MSSQL via PDO ODBC
  4. How can I detect a create, update, delete query is successful in Codeigniter
  5. Connect to SQL Server through PDO using SQL Server Driver
  6. How do I get the SQLSRV extension to work with PHP, since MSSQL is deprecated?
  7. Notice: Array to string conversion in
  8. Should a MAMP return ::1 as IP on localhost?
  9. How to connect to mssql using pdo through PHP and Linux?
  10. How to execute Stored Procedure from Laravel
  11. Getting data with UTF-8 charset from MSSQL server using PHP FreeTDS extension
  12. CodeIgniter MSSQL connection
  13. How to connect sql server with php using xampp?
  14. PHP + SQL Server – How to set charset for connection?
  15. “Adaptive Server is unavailable or does not exist” error connecting to SQL Server from PHP
  16. Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs
  17. How to use PHP to connect to sql server
  18. Linux – PHP 7.0 and MSSQL (Microsoft SQL)
  19. json_encode produce JSON_ERROR_UTF8 from MSSQL-SELECT
  20. SQL Server error 1934 occurs on INSERT to table with computed column PHP/PDO
  21. Get Return Value from SQL Stored Procedure using PHP
  22. Fatal error: Switch statements may only contain one default clause (php7)
  23. Why is using a mysql prepared statement more secure than using the common escape functions?
  24. Merging two json in PHP
  25. How can I know which ‘php.ini’ file is used?
  26. Warning: array_combine(): Both parameters should have an equal number of elements
  27. What are the proper permissions for an upload folder with PHP/Apache?
  28. Is there a limit when using php mail function?
  29. How to get the WordPress post thumbnail (featured image) URL?
  30. Auto Increment skipping numbers?

Leave a Comment