stored procedure to avoid data redundancy

[ssknov]

hi all
i am a beginner, i have written an insert stored procedure.
i need my SP to check for the ID field whether the data is already present.

pls help ,me.

ALTER PROCEDURE [dbo].[SP_SaveGroupClassification]
@SubGroupName nvarchar(50),
--@GroupId int,
@ParentId int,
@ClassType nchar(2),
@RootId int
as
begin
INSERT INTO GroupClassification
(GroupName, ParentId, ClassType, RootId)
VALUES (@SubGroupName,@ParentId,@ClassType,@RootId)
end
return

Here i need to check the value in (@SubGroupName not to be repeated.it is my key field.

thank u

[debasisdas]

You need to check for existance of the record before inserting into the table using COUNT. Insert into the table only count is 0.

[Jim Doherty]

hi all
i am a beginner, i have written an insert stored procedure.
i need my SP to check for the ID field whether the data is already present.

pls help ,me.

ALTER PROCEDURE [dbo].[SP_SaveGroupClassification]
@SubGroupName nvarchar(50),
--@GroupId int,
@ParentId int,
@ClassType nchar(2),
@RootId int
as
begin
INSERT INTO GroupClassification
(GroupName, ParentId, ClassType, RootId)
VALUES (@SubGroupName,@ParentId,@ClassType,@RootId)
end
return

Here i need to check the value in (@SubGroupName not to be repeated.it is my key field.

thank u

Look at (SQL Books online plenty of references) the keyword EXISTS to test for the existence of the value before insertion and if not true only then insert. EXISTS will stop at the first value it finds rather than performing an entire table scan.

Jim :)