-
SQL Insert data in Multiple table and Update at same time
Hi
I have a question about How to insert and update data using Multiple tables . I need to insert data into two SQL table from one query ( insert statement ) and able to update that tables with a one update command . How do I do that . I think I have to use Inner jnoin but it is not working . Can any one give me the syntax of the SQL statement . I am using SQL server 2000 .
Thanks
Similar Threads
-
By dhaya in forum Database
Replies: 11
Last Post: 08-25-2003, 05:24 PM
-
By Gill in forum Database
Replies: 1
Last Post: 08-19-2003, 12:12 PM
-
By Krishna in forum Database
Replies: 1
Last Post: 07-17-2003, 11:36 AM
-
By Bill in forum VB Classic
Replies: 5
Last Post: 10-03-2000, 03:52 PM
-
By VAMM in forum VB Classic
Replies: 2
Last Post: 05-09-2000, 06:03 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|