SQl Server 动态SQL给变量赋值 和OBJECTPROPERTY函数使用及判断表 存储过程 视图等是否存在

--------------------------------------------SQl Server 判断表 存储过程  视图等是否存在--------------------------------------
select * from dbo.sysobjects
where id = object_id(N'ViewName')
and OBJECTPROPERTY(id, N'IsView') = 1

select * from dbo.sysobjects
where id = object_id(N'TableName')
and OBJECTPROPERTY(id, N'IsUserTable') = 1

select * from dbo.sysobjects
where id = object_id(N'ProcecureName')
and OBJECTPROPERTY(id, N'IsProcedure') = 1

 

--------------------------------------------SQl Server  OBJECTPROPERTY函数使用--------------------------------------------
参数博客:http://www.cnblogs.com/greateast/archive/2007/07/31/837312.html

 

--注:函数当中不能用动态SQL
    DECLARE @Sql NVARCHAR(200);
    DECLARE @TableName NVARCHAR(100);
    DECLARE @TOTAL_COUNT INT;--要返回的值
    SET @TableName='YourTableName';
    SET @Sql=N'SELECT @COUNT =ISNULL(MAX(IDENTITYCOL),0) FROM '+@TableName;

    EXECUTE SP_EXECUTESQL @Sql,N'@COUNT INT OUTPUT', @TOTAL_COUNT OUTPUT;
    SELECT @TOTAL_COUNT AS CurMaxID;