DECLARE
@TABLE_NAME sysname,
@sql nvarchar(4000)
SET NOCOUNT ON
CREATE TABLE #temp
(
TABLE_QUALIFIER sysname,
TABLE_OWNER sysname,
TABLE_NAME sysname,
TABLE_TYPE varchar(32),
REMARKS varchar(254)
)
INSERT INTO #temp
EXEC sp_tables 'tbl%' -- change to desired pattern
EXEC sp_executesql N'ALTER TABLE
#temp ADD Processed bit NOT NULL DEFAULT (0)'
WHILE (SELECT COUNT(*) FROM #temp WHERE
Processed = 0) > 0
BEGIN
SET
@TABLE_NAME = (SELECT TOP 1
TABLE_NAME FROM #temp WHERE
Processed = 0)
-- replace next
line with your SQL statement
SET @sql = 'SELECT COUNT(*) FROM '
+ @TABLE_NAME
EXEC sp_executesql @sql
UPDATE
#temp SET Processed =
1 WHERE TABLE_NAME =
@TABLE_NAME
END
DROP TABLE #temp