View Single Post
  #4 (permalink)  
Old November 27th, 2005, 06:57 AM
mcamire mcamire is offline
Registered User
 
Join Date: Nov 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SELECT IDENT_CURRENT('THETABLE') AS myId

Use the IDENT_CURRENT to retreive the last ID from a given table

Reply With Quote