Hi to all! I found an article here in the explained forum as add adena in char. I tried to make with another one procedure that I found. more it is generating an error…. could speak to me where is the error? I go to post scripts to facilitate.
precedure: lin_BetaAddItem
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.lin_BetaAddItem Script Date: 2003-09-20 ?? 11:51:56 ******/
ALTER PROCEDURE [dbo].[lin_BetaAddItem]
(
@char_id int,
@Item_type int,
@amount int
)
AS
SET NOCOUNT ON
DECLARE @tempRowCount INT