小弟在编写一SQL Server 2000存储过程时出现了错误,语法不通过怎么也想不出错误的原因,请大家帮小弟看一看 CREATE PROCEDURE CheckTableName @TableName varchar(15) AS if exists (select * from dbo.sysobjects where id = object_id(@TableName) and OBJECTPROPERTY(id, 'IsUserTable') = 1) drop table @TableName GO 该存储过程实现在当前数据库中检查指定的变量所以代表的数据表是否存在,如果存在,则删除,错误在“drop table @TableName”这句上,出错说“@TableName附近有语法错误” 请大家明示
随便问一下, if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CheckTableName]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CheckTableName] GO 中object_id(N'[dbo].[CheckTableName]')的“N”代表什么意思,有什么用途???