表select*from sysobjects where id=object_id(N'表名')and xtype='U'-表的结构 select*from syscolumns where id=object_id(N'表名')-存储过程 select*from sysobjects where id=object_id(N'存储过程名')and xtype='P' 查询最后修改时间-...
ID 3：存储过程参数放在另一个表，独立查询：select argument_Name as ColumnName,-1 as MaxSize,0 as IsNullable,0 as ReadOnly,'int' as SqlType from user_arguments where object_name=upper(:TableName)4：查询所有表/视图/存储过程 ...
三：主表从表数据一起关联查询 数据库中存在存储过程GetCategory：ALTER proc[dbo].[GetCategory]@cid int as begin select*from Categories where@cid=cid end 执行此存储过程的代码如下：public IEnumerable<Category>...
.[pro_get_table_construct]SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO/*DECRIPTION:查询表的结构的存储过程*VERSION AUTH DATE Defect No DESC*-*V000.0.1 pukuimin 08/03/2012 修改*-*/create procedure[dbo].[pro_get_table_...
原文:sql server 查询某个表被哪些存储过程调用 sql server 查询某个表被哪些存储过程调用 select distinct object_name(id)from syscomments where id in(select id from sysobjects where type=’P’)and text like’%TableName%’
