USE [DBGDnongsan]
GO
/****** Object: StoredProcedure [dbo].[StoretgdGroupIDID] Script Date: 05/28/2011 16:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[StoretgdGroupIDID](
@mode int,
@id int,
@idGroup int,
@nameGroup nvarchar(50)=null,
@ddescription nvarchar(150)=null,
@icon nvarchar(50)=null
)
as
if(@mode = 1) --Them
begin
DBCC CHECKIDENT ('tgdGroupIDID', RESEED, 1)
INSERT INTO tgdGroupIDID VALUES(@idGroup,@nameGroup,@ddescription,@icon)
end
if(@mode = 0) --Sua
begin
if exists(select * from tgdGroupIDID where id = @id)
begin
update tgdGroupIDID set idGroup= @idGroup,nameGroup=@nameGroup,description=@ddescription,icon=@icon where id = @id
end
end
if(@mode =-1) --Xoa
begin
delete from tgdGroupIDID where id = @id
end