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+'] Where ['+@ColName+'] Like @Val)'
		Set @Sql=@Sql+'Set @Rst=1 '
		Set @Sql=@Sql+'Else '
		Set @Sql=@Sql+'Set @Rst=0 '
		Exec sp_Executesql @sql,N'@Val Varchar(4000),@Rst int output',@Val,@Rst output
		If(@Rst=1)
		Insert Into @TB values(@TBName,@ColName) 
		Fetch Next From myCur Into @TBName,@ColName
	End
	Close myCur
	DeAllocate myCur
	Select * From @TB
End
--------------------------------- 
Exec sp_search  '查询内容'
Exec sp_search  '%查询内容%'