View Single Post
  #3 (permalink)  
Old July 23rd, 2003, 05:02 AM
nbryson nbryson is offline
Authorized User
 
Join Date: Jun 2003
Location: Edinburgh, , United Kingdom.
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

This has to be done using multiple statements. e.g.

Insert table1
values ('x', 'x')

declare @ident numeric
select @ident = IDENT_CURRENT('table1')

Insert table2
values (@ident, 'x', 'x')
Reply With Quote