I am inserting some data in a table
Code:
insert into Project VALUES ('Bugger','active') set @iVariable=SCOPE_IDENTITY()
now i want to use this @ivariable to insert its value in another table using java.
Please tell me how to do this?