说ä¸ä¸å ç§æè·¯ï¼
ä¸ãå¦æä½ ç表åæ¯æè§å¾çï¼å°±ç¨å¾ªç¯ç»åæsqlï¼åæ§è¡ãå¦ï¼
declare @i int,@sql varchar(1000)
set @i=1
while @i<10
begin
set @sql='select count(*) from table'+convert(varchar,@i)
exec @sql
end
äºãæ表åä»ç³»ç»è¡¨éååºï¼æ¥ç»æsql
select ''select count(*) from '+name from sysobjects where xtype='u'
åæsqlååºæ¥æ§è¡æ¢å¯ã
ä¸ãå¦æä½ æå
´è¶£ç 究ï¼è¿å¯ä»¥ä½¿ç¨å¾®è½¯æªå
¬å¼çåå¨è¿ç¨æ¥å¤ç sp_MSforeachtableãè¿ä¸ªå°±ä¸è¯¦åäºã
温馨提示:答案为网友推荐,仅供参考