一些比較簡單的預存程序的代碼,主要是本人對這個東西不太熟,特地寫下來!

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