qq_43005276的博客

select distinct object_name(id) from syscomments where id in (select id from sysobjects where type in('V','P')) and text like '%表名%'

存储过程基本语法--判断存储过程是否存在，如果存在了就先删除再创建if (exists (select * from sys.objects where name = 'Pro_User')) drop proc Pro_Usergocreate proc Pro_User as declare @Name varchar(20), @Id varchar(50)begin --逻辑代码 select * from UserInfo where Name=Nam