>Hi gang.... I remember hearing something a while back where someone wanted
>to grab the id of an item they just entered into the database.... all in one
>sql statement.
[sql query here]
SELECT @@IDENTITY AS 'NEW_ID'
Usually you access the NEW_ID as a column in a recordset returned from a stored proc.
You also must be using an identity column (I think.....) for this to work.
>Does anyone remember the sql for that?
>
>----------
>[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays Threads] [<http://www.houseoffusion.com/lists.cfm/link=i:4:172043>This Message] [<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription] [<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4>Fast Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings] [<https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&business=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick>Donations and Support]
>
>----------
><http://www.houseoffusion.com/banners/view.cfm?bannerid=36>
>b4e0cf.jpg
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
