create PROC [dbo].[usp_PRO_GetExecSection]
AS
/*
PAGE: 分类信息维护页    
Action: 添加分类信息
CreatedBy: detian.wang
CreatedDate: 20110408
ModifiedHistory:
Test Scripts:
*/
BEGIN
SET NOCOUNT ON
BEGIN TRY
BEGIN TRAN
--todo .......
select SectionID,Section from tbl_section  where SectionID in(select distinct SectionID from  tbl_ProBusiness);
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
DECLARE @ErrorDesc nvarchar(1000)
DECLARE @CalledUSPName nvarchar(50)
DECLARE @ErrorUSPName nvarchar(50)
SET @ErrorDesc='Error Stored Procedure: ' + ISNULL(ERROR_PROCEDURE(),OBJECT_NAME(@@PROCID)) + '; Line Number: ' + CONVERT(nvarchar(20),ERROR_LINE()) + '; Message: ' + ERROR_MESSAGE()
SET @CalledUSPName=OBJECT_NAME(@@PROCID)
SET @ErrorUSPName=ISNULL(ERROR_PROCEDURE(),OBJECT_NAME(@@PROCID))
EXEC dbo.usp_LogError @CalledUSPName=@CalledUSPName,@ErrorUSPName=@ErrorUSPName,@ErrorDesc=@ErrorDesc
PRINT @ErrorDesc
END CATCH
SET NOCOUNT OFF
END
posted on 2011-04-08 16:11 sanmao 阅读(63) 评论(0)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航:
 

常用链接

留言簿(5)

随笔分类

随笔档案

搜索

  •  

最新评论

阅读排行榜

评论排行榜