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.