Tag Info

New answers tagged

0

---Method 1 using Ident_Current BEGIN TRAN INSERT INTO places (place_name) VALUES ('XYZ') INSERT INTO trips (trip_name) VALUES ('MyTrip') Insert INTO trips_places_asc (trip_id,place_id) values (Ident_Current('trips'), Ident_Current('places')) COMMIT TRAN ---Method 2 Using Scope_Identity ...



Top 50 recent answers are included