alter proc AddJobGroup @ID int,@name nvarchar(100) as begin if not exists(select ID from grooheamaliatesystem where ID=@ID) insert into grooheAmaliateSystem (ID,name)values(@ID,@name) else update grooheamaliateSystem set name=@name where ID=@ID end