CREATE PROCEDURE [dbo].[up_update_pet_name] @pet_id [uniqueidentifier], @character_id [uniqueidentifier], @Name nvarchar(16) as set nocount on update dbo.PetTable set [Name] = @Name where pet_id = @pet_id; return @@error