怎么同时插入多条记录和同时修改多条记录?
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [DBO].[P_HomeWork_Add]
(
@WorkTitle varchar(200),
@WorkDetail ntext,
@Inputer varchar(50),
@Deadline datetime,
@GroupNO varchar(50),
@KeyPath varchar(50)
)
AS
declare @workid int
INSERT INTO SchoolWork ([WorkTitle], [WorkDetail], [Inputer], [Deadline],[KeyPath])
VALUES (@WorkTitle, @WorkDetail, @Inputer, @Deadline,@KeyPath)
set @workid=@@identity
INSERT INTO SchoolWork_Access ([GroupNO], [WorkID])
VALUES(@GroupNO, @workid)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
现在的问题是,我这一条记录可能同时给10个组,也可能给1个组,如果是多组的话,应该怎么处理?
我传进来的组名是first group,或者是second group,如果是多组的话就变成"'first group','second group'"
另外,如果同时修改这10条记录怎么处理?显示记录的时候就显示一条,但这个记录关联10个组,
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [DBO].[P_HomeWork_UPD]
(
@WorkTitle varchar(200),
@WorkDetail ntext,
@Inputer varchar(50),
@Deadline datetime,
@GroupNO varchar(50),
@KeyPath varchar(50),
@workid int
)
AS
update SchoolWork set WorkTitle=@WorkTitle,WorkDetail=@WorkDetail,Inputer=@Inputer,Deadline=@Deadline,KeyPath=@KeyPath where workid=@workid
update SchoolWork_Access set GroupNO=@GroupNO where workid=@workid
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO