How to get last inserted id on ms sql server with FireDac component?

sql sql-server delphi anydac firedac
ae1080 picture ae1080 · Apr 11, 2013 · Viewed 8.5k times · Source

with FireDac, How to get last inserted id on ms sql server? thanks

Answer

Thangamani Palanisamy picture Thangamani Palanisamy · Apr 11, 2013

Make the that id to a identity column and then get it by Using 

SELECT SCOPE_IDENTITY()

after the insert statement

Please refer the following links

http://msdn.microsoft.com/en-us/library/ms190315.aspx

Related questions

Delphi: how to pass a list as a parameter to a SQL query?

I have a list of integers or of strings and need to pass it as a parameter for a Delphi DataSet. How to do it? Here is an example. MyQuery is something like: select * from myTable where intKey in :listParam …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More