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

updating table?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)