Re^2: last_insert

Thanks, fishmonger! any suggestions of what else (funtion, etc) can be used to obtain the last ID? I am using the SELECT statement with the filename and temp_date scalars to obtain the ID but i am sure there must be a better way of getting that ID. Thanks!

Comment on Re^2: last_insert_id issue

Replies are listed 'Best First'.
Re^3: last_insert_id issue by arkturuz (Curate) on Aug 27, 2014 at 18:12 UTC
I have never used SQL Server so far, but after a bit of googling I found the related query. From stackoverflow.com: `SELECT SCOPE_IDENTITY();` [download] From ASP docs: `SELECT CAST(scope_identity() AS int)` [download] Hope this helps. Update: am using the SELECT statement with the filename and temp_date I would suggest you use something more unique, like big random int or long string composed of random chars. temp_date might not be precise enough in a higher traffic environment.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: last_insert_id issue
by arkturuz (Curate) on Aug 27, 2014 at 18:12 UTC

From stackoverflow.com:

SELECT SCOPE_IDENTITY();
[download]

From ASP docs:

SELECT CAST(scope_identity() AS int)
[download]

Update:

am using the SELECT statement with the filename and temp_date

I would suggest you use something more unique, like big random int or long string composed of random chars. temp_date might not be precise enough in a higher traffic environment.

[reply]
[d/l]
[select]