SQL Server2000建立存储过程,提示列名无效,而实际数据库表有该列,请问是何缘故?
存储过程如下:
CREATE PROCEDURE Msg_GetDraft
@personid int,
@msgid int
AS
select a.Title,a.Content,a.SendTo,a.SendToID,a.SecretTo,a.SecretToID,a.Accessory,a.AccessoryID,a.SendDate,a.Important
from
MsgCont a
where
a.MessageID = @msgid
and
a.MsgPersonID = @personid
GO
检查语法,提示SendToID列无效,而实际上msgCont表中有该列.
请大家帮忙看一下.
谢谢谢谢.