主储存过程如下:
ALTER PROCEDURE [dbo].[usp_RefreshAllView]
@name2 VARCHAR(40) OUTPUT
AS
DECLARE @names NVARCHAR(MAX);
DECLARE @name VARCHAR(40);
DECLARE MyCursor CURSOR
FOR
SE LECT name
FROM dbo.sysobjects
WHERE OBJECTPROPERTY(id, N'IsView') = 1
AND ( NOT name IN ( 'sysconstraints', 'syssegments' )
);
OPEN MyCursor;
FETCH NEXT FROM MyCursor
INTO @name;
WHILE ( @@fetch_status <> -1 )
BEGIN
IF ( @@fetch_status <> -2 )
BEGIN
EX EC usp_RefreshAllViewchk @name, @name2 OUTPUT --接收出错返回的值
SE T @names = @names + ',' + @name2; --集合出错的视图
END;
FETCH NE XT FROM MyCursor
INTO @name;
END;
CLOSE MyCursor;
DEALLOCATE MyCursor;
PRINT @names;
调用的子储存过程如下
ALTER PROCEDURE [dbo].[usp_RefreshAllViewchk]
(
@name VARCHAR(40) ,
@name2 VARCHAR(40) OUTPUT
)
AS
BEGIN
BEGIN TRY
EX EC sp_refreshview @name;
END TRY
BEGIN CATCH
SE T @name2 = @name;
RETURN @name2;
END CATCH;
END;
运行主储存过程,当出现第一个有错的视图时出错,
消息 245，级别 16，状态 1，过程 usp_RefreshAllViewchk，第 14 行
在将 varchar 值 'uv_sc002' 转换成数据类型 int 时失败。
哪里 的问题?
谢谢!
加好友 
发短信
Post By：2018/9/28 20:37:00 [显示全部帖子]
此主题相关图片如下：tim截图20180928202552.jpg
