--那个帖里掉了一个空格,不好意思。
DECLARE @SQL VARCHAR(8000)
SET @SQL = ''
SELECT @SQL = @SQL + 'SELECT ' + TableName + ' AS 表名,COUNT(1) AS 数量 FROM ' +
TableName + ' WHERE infoTitle=''hello'' UNION ALL ' FROM TIndex
SET @SQL = LEFT(@SQL, LEN(@SQL) - 10)
EXEC(@SQL)
DECLARE @SQL VARCHAR(8000)
SET @SQL = ''
SELECT @SQL = @SQL + 'SELECT ' + TableName + ' AS 表名,COUNT(1) AS 数量 FROM ' +
TableName + ' WHERE infoTitle=''hello'' UNION ALL ' FROM TIndex
SET @SQL = LEFT(@SQL, LEN(@SQL) - 10)
EXEC(@SQL)
解决方案 »
- SQL SERVER 读取大二进制数据太慢?
- sql2005如何计算一个库里各个表的记录总数
- 请问:如何把存储过程的结果作为子查询的一个表嵌入到查询中?
- 帮改写个简单的SQL 语句
- 求sql语句:将字段导出至文本
- 在mssql裡面,如何用循環,不用遊標
- 求各位大大帮忙,如何提高此存储过程的执行效率,万分感谢,急!!!。
- 用全文搜索是 第一次搜索其慢无比,怎么解决
- Sql Server 频繁地发生超时,向Sql Server 性能有深刻体会的高手请教
- 表转换
- SQL2005中分组及排名问题,狂郁闷
- 郁闷!安装时说”以前某个程序安装以在安装计算机上创建挂起的文件操作,运行安装程序前必须重启计算机“,即使重启也无法安装
SET @SQL = ''
SELECT @SQL = @SQL + 'SELECT ''' + TableName + ''' AS 表名,COUNT(1) AS 数量 FROM ' +
TableName + ' WHERE infoTitle=''hello'' UNION ALL ' FROM TIndex
SET @SQL = LEFT(@SQL, LEN(@SQL) - 10)
EXEC(@SQL)
declare @rowcount int
select distinct @rowcount=count(*) from tindex
declare aaa cursor local scroll
for
select distinct TableTableName from tindex
open aaa
declare @iii nvarchar(max)
declare @jsq int
set @jsq=1
declare @sql nvarchar(max)
while @jsq<=@rowcount
begin
fetch absolute @jsq from aaa into @iii
set @sql='select * from '+@iii
select @iii
exec sp_executesql @sql
set @jsq = @jsq + 1
end
set nocount off
看我的哈哈
AS
BEGIN
set nocount on
declare @rowcount int
select distinct @rowcount=count(*) from t_index
declare aaa cursor local scroll
for
select distinct name from t_index
open aaa
declare @iii nvarchar(max)
declare @jsq int
set @jsq=1
declare @sql nvarchar(max)
while @jsq<=@rowcount
begin
fetch absolute @jsq from aaa into @iii
set @sql='select count(*) from '+@iii+ ' where infoTitle=''hello'''
select @iii as 表名
exec sp_executesql @sql
set @jsq = @jsq + 1
end
set nocount off
END