sql2005存储过程对象名无效
setANSI_NULLSONsetQUOTED_IDENTIFIERONGOALTERPROCEDURE[dbo].[ADD]@UIDint,@objectTypein...
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ADD]
@UID int,
@objectType int,
@objectID int,
@comment int,
@m_content text,
@actionTime datetime,
@actionIP varchar(20),
@status int,
@memo varchar(200)
as
BEGIN
select @uid=count(uid) from U_UserBasic order by newid();
INSERT INTO M_object_Comment(UID, objectType, objectID, comment, m_content, actionTime, actionIP, status, memo) VALUES (@UID, @objectType, @objectID, @comment, @m_content, @actionTime, @actionIP, @status, @memo);
END;
消息 208,级别 16,状态 6,过程 ADD,第 14 行
对象名 'dbo.ADD' 无效。 展开
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ADD]
@UID int,
@objectType int,
@objectID int,
@comment int,
@m_content text,
@actionTime datetime,
@actionIP varchar(20),
@status int,
@memo varchar(200)
as
BEGIN
select @uid=count(uid) from U_UserBasic order by newid();
INSERT INTO M_object_Comment(UID, objectType, objectID, comment, m_content, actionTime, actionIP, status, memo) VALUES (@UID, @objectType, @objectID, @comment, @m_content, @actionTime, @actionIP, @status, @memo);
END;
消息 208,级别 16,状态 6,过程 ADD,第 14 行
对象名 'dbo.ADD' 无效。 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询