未记录的系统过程'sp_MSforeachtable'和@whereand参数(Undocumented System Procedure 'sp_MSforeachtable' and the @whereand parameter)

 我正在尝试使用未记录的系统过程sp_MSforeachtable 。 但是我需要将受影响的表限制为以“smp”开头并且在“ dbo ”模式中的表。 我能够找到如何找到以“smp”开头的程序。 我只是这样做： 
 
sp_MSforeachtable @command1=' print ''?''', @whereand=' and name like ''smp%''  '
 
 但是如何使用@whereand参数过滤给定的模式？ 
 
 更新 ：我尝试了以下但它没有工作： 
 
sp_MSforeachtable @command1=' print ''?''', @whereand=' and name like ''smp%'' and Left(''?'', 5)=''[dbo]'' '
 
 更新2 ：我在SQL Server 2000上运行。 

I'm attempting to use the undocumented system procedure sp_MSforeachtable. But I need to restrict the affected tables to those that start with "smp" and that are in the "dbo" schema. I was able to find how to find procedures that start with "smp". I simply do: 
 
sp_MSforeachtable @command1=' print ''?''', @whereand=' and name like ''smp%''  '
 
but how do I filter for a given schema using the @whereand parameter? 
 
UPDATE: I tried the following but it didn't work:
 
sp_MSforeachtable @command1=' print ''?''', @whereand=' and name like ''smp%'' and Left(''?'', 5)=''[dbo]'' '
 
Update 2: I'm running on SQL Server 2000. 

原文：https://stackoverflow.com/questions/977400