Re: odbc
| From: | Alejandro Garín | Date: | Tue, 07 Nov 2000 15:55:23 +0000 |
| Subject: | Re: odbc | ||
| References: | 1 | Groups: | php.general.es |
| Request: | Send a blank email to general-es+get-3383@lists.php.net to get a copy of this message | ||
>Ale gracias pero lo que necesito es que atraves de odbc para access o para
>sqlserver o para cualquier base de datos me de el ultimo elemnto id
>insertado?
Encontre esto para Sql server 7, sirve?
@@IDENTITY
After 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. 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.
Examples
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'
saludos,
---------------------
Alejandro Diego Garín
Telecom Internet
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
mQGiBDoG3UYRBAD9DNDwPQRUg8W1BL5mOBdtHWdCLmPCqH+xt4DUsTHHZC1hgydH
ixiFsPELT7w2mTyGYdVJzCWLl2wvqAVNan7YB419U+qveFZ6bVMbaZuR9IMuSLpV
LojMZ+P+tArWOa5Nmvo9GYNwM3DBP1GoqSwMt3EKSaH1d+tF2/sqHXSfHQCg/9xV
+jfDaQaK4RvusVUwplQy3AMEAJfMAK0elQTRzEFe5BH+zQ8lQ/9LOGT9mUwZ+8ax
IAJWEHTzHw/iB2wKRHD3Uf5I65qiN2pgCjKNxD6r7oXJsQS8Rn/2cL+9FJUZ+ncL
Yx2MHqKiWsxQ05bTCW3UP8HjaV+eaxvExR7nkUbJt5WImaM1kZhIYPJjORU9GTWC
2wBfBADvMzmFRmWUjzs4i2lnNU10KjRHnHk4Sy0DSZZ+iJ5Zy5vcZzRXT0tLph5n
obuysL3CC2Qtc/MWjX1YOofvWT8QSgP4vYOmDrKklF997DlgH7EK0asibvLFLAdP
zWpEg79UHqVn6NDI45Yo/p5l/P7h7yukkOdO1pseGFdhwx1HBrQrQWxlamFuZHJv
IERpZWdvIEdhcu1uIDxhZ2FyaW5AYXJuZXQuY29tLmFyPokAVAQQEQIAFAUCOgbd
RgUJAeEzgAQLAwIBAhkBAAoJEJYLPProARrF3MMAnRQ1Ep0qkeM/Gq/QEGrTq/k9
gaBWAKCUtUabeW4rn4twCxcEO/jPUWcJhrkCDQQ6Bt1GEAgA9kJXtwh/CBdyorrW
qULzBej5UxE5T7bxbrlLOCDaAadWoxTpj0BV89AHxstDqZSt90xkhkn4DIO9ZekX
1KHTUPj1WV/cdlJPPT2N286Z4VeSWc39uK50T8X8dryDxUcwYc58yWb/Ffm7/ZFe
xwGq01uejaClcjrUGvC/RgBYK+X0iP1YTknbzSC0neSRBzZrM2w4DUUdD3yIsxx8
Wy2O9vPJI8BD8KVbGI2Ou1WMuF040zT9fBdXQ6MdGGzeMyEstSr/POGxKUAYEY18
hKcKctaGxAMZyAcpesqVDNmWn6vQClCbAkbTCD1mpF1Bn5x8vYlLIhkmuquiXsNV
6TILOwACAgf/VUy7yUpXj9MfVlcdJzBMAbj2uIQoWpU9sDRwIPN77BQ+BPi48FWp
Kw9zu+XBUbBgsKobOAYFXWTgZNOs+5Snpuss/z2Kw7/GWwW7pyK3SxSZ76w9mQ/4
xIOxfpukp7KP9OhcdMoBDyL1zPFNOEw6sSSMpPlQWUb3HiR9WXm86eNkBJZt+KF/
DKocG4lFQRhk7YqdruX3UgNxJhFxMz5JOW5EkU77YSxYwkyZQFJFwROqWtgTmtOU
Zz9VRozsove5O39h5iLkWiecZhKJGAAIOW6braLIHRqO8i6sCflgI1pWAQe2QZTP
chxU3TusPY//N7SLESrojKND533t4DnsLYkATAQYEQIADAUCOgbdRgUJAeEzgAAK
CRCWCzz66AEaxSnDAKCyea3+Mx32xpEC9bV7112ru/nlvgCgnK3P9cYXfcA++rUK
bzvTkQijazU=
=djSB
-----END PGP PUBLIC KEY BLOCK-----
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com