Code:
DB:{call sp_UpdatePetSkin(1240,147,98,2,100,21600,?)}
DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'sp_UpdatePetSkin'.Big thanks if you share
Code:
USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_UpdatePetSkin] Script Date: 8/18/2022 12:03:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_UpdatePetSkin]
@nChaNum int,
@nPetNum int,
@nPetSkinMID int,
@nPetSkinSID int,
@nPetSkinScale int,
@nPetSkinTime int,
@nReturn int OUTPUT
AS
BEGIN
DECLARE
[USER=116066]ERROR[/USER]_var int,
[USER=349225]Row[/USER]count_var int
SET NOCOUNT ON
SET @nReturn = 0
UPDATE dbo.PetInfo
SET PetSkinMID = @nPetSkinMID,
PetSkinSID = @nPetSkinSID,
PetSkinScale = @nPetSkinScale,
PetSkinTime = @nPetSkinTime,
PetSkinStartDate = getdate()
WHERE PetNum = @nPetNum AND PetChaNum = @nChaNum
SELECT [USER=116066]ERROR[/USER]_var = [USER=116066]ERROR[/USER], [USER=349225]Row[/USER]count_var = [USER=349225]Row[/USER]COUNT
IF [USER=116066]ERROR[/USER]_var <> 0 OR [USER=349225]Row[/USER]count_var = 0
BEGIN
SET @nReturn = -1
END
ELSE
BEGIN
SET @nReturn = 0
END
RETURN @nReturn
END
