How to update two or more table usin one Stored Procedure

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Anders Pedersen SSChampion Points: 11410 More actions · Answer 1

Yes. Just use two seperate update statements

create procedure usp_UpdateTwoTables

as

begin

update table1

set Column1 = 'a'

update table2

set Column2 = 'b'

end

Gordon Pollokoff SSCommitted Points: 1930 More actions · Answer 2

create procedure usp_UpdateTables

@value varchar(50)

as

BEGIN

UPDATE table1

SET col1 = @value

UPDATE table2

SET colA = @value

END

Gordon Pollokoff

"Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones