Help on this stored procedure

[Cruzader]

Peeps, plz help

ALTER PROCEDURE dbo.AddItemRecord
(
@id int = NULL,
@description int = NULL,
)
AS

SELECT COUNT(*) AS idnumber FROM ITEM;

INSERT INTO Item
(id, description)
VALUES (@id,@description)


unsaon nako pagset na kanang resulta na idnumber, mabutang sa id na variable. Thanks

[torade]

Try this one bro:

ALTER PROCEDURE dbo.AddItemRecord
(
@id int = NULL,
@description int = NULL
)
AS

SELECT @id = COUNT(*) FROM ITEM;

INSERT INTO Item
             (id, description)
VALUES    (@id,@description)

I just notice na you update you @id variable from within the Script, I suggest not to declare @id as parameter of SP but rather a variable within the script like:

ALTER PROCEDURE dbo.AddItemRecord
(
  @description int = NULL
)
AS

Declare @id int;

SELECT @id = COUNT(*) FROM ITEM;

INSERT INTO Item (id, description)
VALUES (@id,@description)

[Cruzader]

Thanks bro

[torade]

No problem :mrgreen:, glad that I could help.