updating table?

Question

how many types we Updating one table based on the other table?

Hariharan Krishnamoorthi · Answer

You can update a table by using joins with other table.

Rafnas T P · Answer

hi can you tell me what is your exact requirement

Bikesh Srivastava · Answer

Whats your project requirment because there are many way to update info in table.

Amit Kumar · Answer

Hi You can create a procedure and then you can use multiple sql commands like. Create a simple procedure here.. CREATE PROCEDURE prc_update ( @table1_id INT @table2_id INT @table3_id INT @new_value INT) AS BEGIN UPDATE Table1 SET field1 = @ new_value WHERE id = @ table1_id UPDATE Table2 SET field2 = @ new_value WHERE id = @ table2_id UPDATE Table3 SET field3 = @ new_value WHERE id = @ table3_id END For more details follow the below link. http://stackoverflow.com/questions/2432612/sql-and-multiple-statements-in-stored-procedure

Ashok · Answer

Hi Donthu Am not understanding how to use store produce executing multiple command in sql table please let me know the clearly. If you have time.

D Donthu · Answer

As per my understanding we update (or) add table values based on other table .you use store produce executing multiple command in sql table