I am inserting rown into my data table and would like to be able to
retriever id of the row inserted immediatelly after it has been inserted.
How can I do that?

Regards, Dino
--


-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com

Look at SCOPE_IDENTITY ()

Ronen

"Dino M. Buljubasic" <dino.buljubasic (AT) rivusglobal (DOT) com> wrote

If you are using an sproc, simply use an output parameter.

"Dino M. Buljubasic" <dino.buljubasic (AT) rivusglobal (DOT) com> wrote

On Wed, 03 Dec 2003 23:59:19 GMT, "Dino M. Buljubasic" <dino.buljubasic (AT) rivusglobal (DOT) com> wrote:

¤
¤ I am inserting rown into my data table and would like to be able to
¤ retriever id of the row inserted immediatelly after it has been inserted.
¤ How can I do that?

This feature is dependent upon support from the database and driver - what type of database are you
working with?


Paul ~~~ pclement (AT) ameritech (DOT) net
Microsoft MVP (Visual Basic)

http://www.inwowgold.com/
http://www.inwowgold.com/power-leveling/

http://www.sopgame.com/
http://www.sopgame.com/power-leveling/


From http://www.google.cn/search?hl=zh-CN&num=100&newwindow=1&q=Spam+Filter+*+inurl:Post. aspx?ID=&btnG=Google+??&aq=f&oq=

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

Replica Watches
http://www.prettyreplica.com
Replica Handbags, Very Nice Bag
http://www.verynicebag.com
Fashion Watches
http://www.watchesbroker.com
Very Nice Watch
http://www.buynicewatch.com
Discount Watches
http://www.prettyreplica.com/specials.html
Best Watches
http://www.watchesbroker.com
Special Watches
http://www.watchesbroker.com/specials.html
Fashion Bags
http://www.hotpopbag.com

http://www.dogbreedss.org/puppy-names.htm
structural diseases health disorders of dogs - causes, symptoms and possible
treatment.
http://www.dogbreedss.org/dog-diseases.htm