SQL Server中查询一个值出现的所有表。

Create Procedure sp_Search(@Val Varchar(4000))
As
Begin
	Declare @TBName Varchar(200)
	Declare @ColName Varchar(200)
	Declare @Rst int
	Declare @Sql NVarchar(4000)
	Declare @TB Table(TbName Varchar(200),ColName Varchar(200))
	
	Declare myCur Cursor For 
		Select A.Name,B.Name From sys.objects A Inner join sys.columns B on a.object_id=b.object_id
			Where A.Type='U' And system_Type_ID in(35,99,167,175,231,239)

	Open myCur;

	Fetch Next From myCur Into @TBName,@ColName
	While @@FETCH_STATUS = 0
	Begin
		Set @Sql='If Exists(Select * From ['+@TBName+'