Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ID ContactName1 Designation1 ContactName2 Designation2
- 1 A dummy B sam
- ID ContactName Designation
- @ContactName1
- @Designation1
- @ContactName2
- @Designation2
- INSERT INTO DataTable (ContactName, Designation) VALUES
- (@ContactName1, @Designation1),
- (@ContactName2, @Designation2);
- SELECT MAX(ID) AS max_id FROM DataTable
- INSERT INTO Table(ID, ContactName, Designation)
- VALUES(1, @ContactName1, @Designation1)
- VALUES(1, @ContactName2, @Designation2);
Add Comment
Please, Sign In to add comment