sp command

[rbringas]

Hello everyone...A newby at SQL server. I'm being asked this question:

I'm looking at a stored procedure and there is a command I don't know.

it is

set @page_id=@@IDENTITY

now I know that @page_id is a user defined variable, but I don't know what the @@IDENTITY is. I looked at my sql manuals here and it does not say. So I think it is a sql 7 syntax or reserved word. Its not used in oracle or sybase which I have manuals here for.

Thanks in advance.

 

[balves]

It retrieves the last identity value created.

From the BOL:

This example inserts a row into a table with an identity column and uses @@IDENTITY to display the identity value used in the new row.

INSERT INTO jobs (job_desc,min_lvl,max_lvl)

VALUES ('Accountant',12,125)

SELECT @@IDENTITY AS 'Identity'

 

[rbringas]

Thank you very much for your help.