Question

请高手帮忙：SQL Sserver 2000数据库存储过程出现“列名 'object_id' 无效。”的错误，谢谢！

在sql server 2000查询分析器中输入的脚本代码如下：
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StoredProcedureIsFull]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[StoredProcedureIsFull]
(
@roomID char(4)
)
AS
Update Room Set IsFull=1 Where RoomID=@roomID
RETURN
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StoredProcedureAddClient]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[StoredProcedureAddClient]
(
@roomID char(4)

)
AS
Update Room Set FactPeopleNum=FactPeopleNum+1 Where RoomID=@roomID
RETURN
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StoredProcedureMinusClient]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[StoredProcedureMinusClient]
(
@roomID char(4)

)
AS
Update Room Set FactPeopleNum=FactPeopleNum-1 Where RoomID=@roomID
RETURN
'
END

Answer 1

SQL2008后的版本才有'object_id'吧