|
declare?? @tablename?? varchar(100)??
? declare?? @sql?? nvarchar(4000)??
? declare?? @Num?? int??
? declare?? tb_cursor?? scroll?? cursor?? for?? select?? name?? from?? sysobjects?? where?? xtype='U'??
??????????? open?? tb_cursor????
??????????? fetch?? next?? from?? tb_cursor?? into?? @tablename??
??????????? while?? @@fetch_status=0????
??????????? begin????
??????????????????? set?? @sql=N'select?? @Num=count(1)?? from?? '+@tablename???? ??????????????????? exec?? sp_executesql?? @sql,N'@Num?? int?? out',@Num?? out???? ??????????????????? if?? @Num>0?? print?? @tablename?? ??????????????????? fetch?? next?? from?? tb_cursor?? into?? @tablename?? ??????????? end???? ??????????? close?? tb_cursor???? ??????????? deallocate?? tb_cursor
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
