Multiple updates in one stored procedure!

[angst11]

Is there a way to have multiple updates in one stored procedure! I have ten update statements that need to be executed based on the parameters that are passed! Can this be done in one stored procedure?

 

[swampBoogie]

Yes, no problem. E.g.

create procedure p(@nv1 varchar(20),@pk1 int,
@nv2 varchar(20),@pk2 int)
as
set nocount on
update t1 set c1 = @nv1 where pk = @pk1
update t2 set c2 = @nv2 where pk = @pk2



Uou can add as many statement as you need.

 

[SQLSister]

You can also put them all in one transaction so if any one fails they will all be rolled back.