who can show me these procedure

Results 1 to 2 of 2
  1. #1
    Member fyrjzy is offline
    MemberRank
    May 2012 Join Date
    99Posts

    who can show me these procedure

    who can share the procedures :
    atum_GetCollectionList
    atum_UpdateCollectionInfo
    atum_Get_ShapeStatLevel
    atum_Insert_ShapeStatLevel

    thanks....

    #####################################
    who can send other procedure??
    solve two procedure, like this :
    Code:
    	CREATE PROC [dbo].[atum_Insert_ShapeStatLevel]
    		@i_ItemKind			TINYINT,
    		@i_ItemUID			BIGINT,
    		@i_ShapeItemNum		INT,
    		@i_AllStatLevel		INT
    		AS
    		
    		BEGIN
    		DECLARE @ResultCnt	INT
    		SELECT @ResultCnt = COUNT(*) FROM [dbo].[td_ShapeStatLevel]  WITH(NOLOCK) WHERE [ItemUID] = @i_ItemUID
    		
    		IF( @ResultCnt != 0 )
    			BEGIN
    				UPDATE [dbo].[td_ShapeStatLevel]  SET [ShapeItemNum] = @i_ShapeItemNum, [AllStatLevel] = @i_AllStatLevel
    				WHERE  [ItemUID] = @i_ItemUID 
    			END
    		ELSE
    			BEGIN
    				INSERT INTO [dbo].[td_ShapeStatLevel] ([ItemKind],[ItemUID],[ShapeItemNum],[AllStatLevel]) 
    				VALUES (@i_ItemKind, @i_ItemUID, @i_ShapeItemNum,@i_AllStatLevel)
    			END
    		END
    	GO
    Code:
    	CREATE PROC [dbo].[atum_Get_ShapeStatLevel]
    		@i_ItemUID			BIGINT
    		AS
    		
    		BEGIN
    			SELECT [ItemKind],[ItemUID],[ShapeItemNum],[AllStatLevel] FROM [dbo].[td_ShapeStatLevel] WITH(NOLOCK)
    			WHERE [ItemUID] = @i_ItemUID
    		END
    	GO
    Last edited by fyrjzy; 22-10-14 at 03:23 AM.


  2. #2
    Proficient Member SHREC is offline
    MemberRank
    Jul 2011 Join Date
    188Posts

    Re: who can show me these procedure

    Whats procedure?? Where you seek proced? where parametr procedury?



Advertisement