SQL2005存储过程的问题:消息 208,级别 16,状态 6,过程 InsertBbsTitle,第 22 行
存储过程如下:
ALTER PROCEDURE [dbo].[InsertBbsTitle]
(
@CategoryId Int,
@UserId UNIQUEIDENTIFIER,
@UserName VARCHAR(50),
@Title VARCHAR(500),
@Body TEXT,
@CreateDate datetime,
@UpdateDate datetime,
@ZhiDing bit,
@JingHua bit,
@ChuFaDi VARCHAR(500),
@ChuYouRiQi DATETIME,
@MuDiDi VARCHAR(500),
@JiaoTongGongJu VARCHAR(50),
@ChuYouTianShu VARCHAR(50),
@LuZhuJiuDianXiJi VARCHAR(50),
@ChuYouFeiYong VARCHAR(50)
)
as
insert into Jxly_Bbs_Title
(
CategoryId,
UserId,
UserName,
Title,
Body,
CreateDate,
UpdateDate,
ZhiDing,
JingHua,
ChuFaDi,
ChuYouRiQi,
MuDiDi,
JiaoTongGongJu,
ChuYouTianShu,
LuZhuJiuDianXiJi,
ChuYouFeiYong
)
values
(
@CategoryId,
@UserId,
@UserName,
@Title,
@Body,
@CreateDate,
@UpdateDate,
@ZhiDing,
@JingHua,
@ChuFaDi,
@ChuYouRiQi,
@MuDiDi,
@JiaoTongGongJu,
@ChuYouTianShu,
@LuZhuJiuDianXiJi,
@ChuYouFeiYong
)
但执行时提示:
消息 208,级别 16,状态 6,过程 InsertBbsTitle,第 22 行
对象名 'dbo.InsertBbsTitle ' 无效。
什么原因啊?急急急。
------解决方案--------------------你是创建还是修改啊
创建的话 CREATE PROCEDURE [dbo].[InsertBbsTitle]