updating table?

Ashok

9y976

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hariharan Krishnamoorthi9y ago
You can update a table by using joins with other table.
0
Rafnas T P9y ago
hi,

can you tell me what is your exact requirement

0
Bikesh Srivastava9y ago
Whats your project requirment ,because there are many way to update info in table.
0

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

Ashok9y ago
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.
0
D Donthu9y ago
As per my understanding ,we update (or) add table values based on other table .you use store produce executing multiple command in sql table
0