create proc RegionUpdate
(
@Name varchar(20),
@Age int
)
as set nocount off
begin
update person
set age = @Age where name = @Name
end;
(
@Name varchar(20),
@Age int
)
as set nocount off
begin
update person
set age = @Age where name = @Name
end;
AS
SET NOCOUNT OFF
BEGIN
UPDATE person
SET age = @Age
WHERE NAME = @Name
END
GO