Multiple Table Update
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I have a scenario to Update 8 tables at a time All the 8 tables are having a same column, that i have to set the value based on the field I have the receivable tables havind a column InvoiceId, if i pass one invoiceid to sp or query, based on the InvoiceId i have to set the value null for that i know only to write the 8 UPDATE query statements, if u have any other idea means Please Guide Me Thanks
-