Recuperar ultimo registro inserido

[João Francisco 0]

E ai João Francisco beleza ?

 

É o seguinte esta usando sql server não é.... ?

 

Me manda seu insert que eu monto uma procedure para você explico como ela funciona e como você pegar todos os valores...

 

Estou indo almoçar agora assim que chegar eu monto manda ai que monto a inserção e o retorno ja e te explico como funciona beleza...

 

Abraços kara fui

Falae Filipe!

Kra.. é esse código q tá aí em cima.. mas vou mandar novamente, a parte que eu recebo os dados, gravo e tento recuperar:

 

Strdtinicio 	= Request.Form("dtinicio")	Strdtfim 		= Request.Form("dtfim")	Strnomeevento 	= Request.Form("nomeevento")	Strloc	 		= Request.Form("loc")	Strvalores		= Request.Form("valores")	Strfone			= Request.Form("fone")	Strcontato		= Request.Form("contato")	Stremail		= Request.Form("email")		Strurl			= Request.Form("url")	Strtexto		= Request.Form("texto")	Strobs			= Request.Form("obs")				'********** CADASTRANDO O EVENTO **********SQL = "Insert Into CadastroEventos(dtinicio,dtfim,nomeevento,loc,valores,fone,contato,email,url,texto,obs) values('"&Strdtinicio&"','"&Strdtfim&"','"&Strnomeevento&"','"&Strloc&"','"&Strvalores&"','"&Strfone&"','"&Strcontato&"','"&Stremail&"','"&Strurl&"','"&Strtexto&"','"&Strobs&"')"Cn.Execute(SQL)Set RsCadEvento = Cn.Execute("SELECT id FROM CadastroEventos WHERE id = LAST_INSERT_ID()")

Aguardo sua resposta!! Abraços..

 

Ahh.. esqueci de dizer.. não estou usando SQL Server não, estou usando Access msm!! =]

 

Té mais

[ZioNN 0]

Achei uma explicação detalhada no site da MSDN. (Pra SQL Server 2000)Transact-SQL Reference (SQL Server 2000)@@IDENTITYReturns the last-inserted identity value.Syntax@@IDENTITYReturn TypesnumericRemarksAfter an INSERT, SELECT INTO, or bulk copy statement completes, @@IDENTITY contains the last identity value generated by the statement. If the statement did not affect any tables with identity columns, @@IDENTITY returns NULL. If multiple rows are inserted, generating multiple identity values, @@IDENTITY returns the last identity value generated. If the statement fires one or more triggers that perform inserts that generate identity values, calling @@IDENTITY immediately after the statement returns the last identity value generated by the triggers. If a trigger is fired after an insert action on a table that has an identity column, and the trigger inserts into another table that does not have an identity column, @@IDENTITY will return the identity value of the first insert. The @@IDENTITY value does not revert to a previous setting if the INSERT or SELECT INTO statement or bulk copy fails, or if the transaction is rolled back.@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT are similar functions in that they return the last value inserted into the IDENTITY column of a table. @@IDENTITY and SCOPE_IDENTITY will return the last identity value generated in any table in the current session. However, SCOPE_IDENTITY returns the value only within the current scope; @@IDENTITY is not limited to a specific scope.IDENT_CURRENT is not limited by scope and session; it is limited to a specified table. IDENT_CURRENT returns the identity value generated for a specific table in any session and any scope. For more information, see IDENT_CURRENT.The scope of the @@IDENTITY function is the local server on which it is executed. This function cannot be applied to remote or linked servers. To obtain an identity value on a different server, execute a stored procedure on that remote or linked server and have that stored procedure, which is executing in the context of the remote or linked server, gather the identity value and return it to the calling connection on the local server.ExamplesThis 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'