lucky20
asked on
could n't create a stored procedure?
is any thing wrong with this procedure?It is giving lot of errors
CREATE PROCEDURE [dbo].sp_item
@iitemid int
@item varchar(20)
@quantity decimal(10,2)
BEGIN
insert into items(itemid,item,quantity )values(@i itemid,@it em,@quanti ty)
END
GO
CREATE PROCEDURE [dbo].sp_item
@iitemid int
@item varchar(20)
@quantity decimal(10,2)
BEGIN
insert into items(itemid,item,quantity
END
GO
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.