if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SystemSet]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
if exists (select 1 from sysobjects where id=object_id(表名) and xtype='U')
CREATE PROCEDURE TableExist @tablename varchar(40) AS if exists (select 1 from sysobjects where id=object_id(@lastname) and xtype='U') print 'Exists'+@lastname else Print 'Not Exists'+@lastname
修改一下: CREATE PROCEDURE TableExist @tablename varchar(40) AS if exists (select 1 from sysobjects where id=object_id(@tablename) and xtype='U') print 'Exists'+@tablename else Print 'Not Exists'+@tablename
@tablename varchar(40)
AS
if exists (select 1 from sysobjects where id=object_id(@lastname) and xtype='U')
print 'Exists'+@lastname
else
Print 'Not Exists'+@lastname
CREATE PROCEDURE TableExist
@tablename varchar(40)
AS
if exists (select 1 from sysobjects where id=object_id(@tablename) and xtype='U')
print 'Exists'+@tablename
else
Print 'Not Exists'+@tablename