SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
--<table comment>
--操作表名:News
--表说明:
--方法说明:向表中添加一条记录
--</table comment>
ALTER PROCEDURE dbo.p_ch_WriterNewsAdd
(
@Title varchar(255),
@Content ntext,
@NewsSource varchar(50),
@Keywords varchar(255),
@IP varchar(15),
@NewsTypeID int,
@Checkintime datetime,
@ConfirmStatus tinyint
)
AS
BEGIN TRAN
INSERT INTO News (
Title,
Content,
NewsSource,
Keywords,
IP,
NewsTypeID,
Checkintime,
ConfirmStatus
)
VALUES (
@Title,
@Content,
@NewsSource,
@Keywords,
@IP,
@NewsTypeID,
@Checkintime,
@ConfirmStatus
)
IF @@ERROR!=0
BEGIN
ROLLBACK TRAN
RAISERROR 20000 'p_ch_NewsAdd: Cannot insert data into p_ch_NewsAdd'
RETURN(1)
END
COMMIT TRAN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
//
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
--<table comment>
--操作表名:ConsultationCatalogs
--表说明:
--方法说明:更新表中记录
--</table comment>
ALTER PROCEDURE dbo.p_fyb_ConsultationCatalogsUpdate
(
@Name varchar(20),
@ParentID int,
@CatalogID int
)
AS
BEGIN TRAN
UPDATE ConsultationCatalogs SET
Name = @Name,
ParentID = @ParentID
WHERE CatalogID=@CatalogID
IF @@ERROR!=0
BEGIN
ROLLBACK TRAN
RAISERROR 20000 'p_fyb_ConsultationCatalogsUpdate: Cannot update data on p_fyb_ConsultationCatalogsUpdate'
RETURN(1)
END
COMMIT TRAN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO