> One table will insert into the tableUsers and then I will insert into > tableQuestions. In > tableQuestions i will want to put the contents of the userID which i just > inserted into > tableUsers. > > Can anyone tell me how I can get the exact userID which I just inserted so I > can put into > my tableQuestions table?
I use stored procedures for most of the SQL Server stuff so I build in the @@Identity function into the procedures. Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203185 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
