存储过程事例

////////////////////////////////存储过程

--彻底删除内容
--drop PROCEDURE Content_DeleteContent

ALTER PROCEDURE [dbo].[Content_DeleteContent]
 @ContentIDs ntext
AS
BEGIN
 --删除自定义字段的值
    exec('delete from SelfFormContent where ContentID in(' + @ContentIDs + ')')

 --删除所有页面
    exec('delete from ContentPages where ContentID in(' + @ContentIDs + ')')

 --删除所有文章来源关联
    exec('delete from ContentSourceLink where  ContentID in(' + @ContentIDs + ')')

 --删除相关文章
    exec('delete from ContentRelation where  ContentID in(' + @ContentIDs + ') or RelContentID in(' + @ContentIDs + ')')

 --删除基础内容
 exec('delete from ContentBaseInfo where  ContentID in(' + @ContentIDs + ')')

END

////////////////////////////////调用方法

        /// 删除文章
        /// <summary>
        /// 删除文章
        /// </summary>
        /// <param name="ContentIDs"></param>
        public static void DeleteContent(string ContentIDs)
        {
            SqlParameter[] _para =
            {
             new SqlParameter("@ContentIDs",SqlDbType.NVarChar)
            };
            _para[0].Value = ContentIDs;

            DBHelper.CommandRun(CommandType.StoredProcedure, "Content_DeleteContent", _para);
        }