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 GOCode: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



Reply With Quote

